LibreOffice Calc:如何将未格式化的文本转换为数字(或其他格式) [英] LibreOffice Calc: How to convert unformatted text to numbers (or other format)
问题描述
如何将未格式化的文本(例如,csv或制表符分隔)粘贴到LibreOffice Calc中,然后将其格式化为数字(无需手动编辑每个单元格).当我将文本粘贴到下面时,它会在所有内容前面加上一个',因此,如果我尝试将其转换为数字,则仍然是文本.
How do I paste unformatted text (csv or tab delimited for instance) into LibreOffice Calc and then format it as numbers (without editing every cell by hand). When I paste the text below it puts a ' in front of everything so if I try to convert it to a number it's still text.
Text 0.01% 3% 5.1%
Asdf 0.2% 4% 6.0%
因此,例如,如果我将特殊文本粘贴为带有空格分隔符的未格式化文本,然后将0.01%转换为数字(如果满足我的要求,则将显示0.0001),现在它在单元格中显示为'0.01%. /p>
So for example if I paste special that as unformatted text with space delimiters and then convert 0.01% to a number (which would then say 0.0001 if it did what I wanted), it now says '0.01% in the cell.
推荐答案
此过程已在LibreOffice 4.0.2中进行了测试.粘贴为未格式化的文本,然后选择以下选项:
This procedure is tested in LibreOffice 4.0.2. Paste as unformatted text, and choose the following options:
- 选择英语作为语言,或选择其他使用句点作为小数点分隔符的语言.
- 选择检测特殊号码".
现在,百分比将粘贴为数字而不是文本,并且您可以使用格式选项以自己喜欢的方式显示它们.
Now the percentages will be pasted as numbers instead of text, and you can use the format options to display them the way you like.
这篇关于LibreOffice Calc:如何将未格式化的文本转换为数字(或其他格式)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!