configure Openoffice Sheet to recognize numbers

uxan · 12-12-2007, 10:01 AM

i have installed OpenOfice Sheet on my computer under Linux Operating System(Fedora 7) but when i copy data from a web page and paste into it , it takes the datas as text not as numeric number.How can i configure it to recognize those datas as numeric numbers

Help me

matthewg42 · 12-12-2007, 10:08 AM

Can you provide an example of the data you are pasting?

pixellany · 12-12-2007, 12:16 PM

I think you mean OpenOffice Calc (spreadsheet program)

I think that in any spreadsheet SW, mixed letters and numbers will be interpreted as text. Some quick tests with Calc shows these non-numeric characters that are treated "numerically": "+", "-", ".", "$", "%". Are there more???

Interestingly:
65- is converted to -65
+78 OR 78+ both come out as just 78

BUT:
65+23 is read as text