On 10/12/2007 23:57, Pierre wrote:
I have been given a very large spreadsheet to work on.
What should be numeric (integer) values appear to be text or string
values, that is 100 is entered as '100
Is there a quick way to convert the text values back to numeric ones?
TIA
Pierre
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Not sure if this is the quickest way but ...
Save the file as a .csv (Comma Separated Values) file. This will save
your values as strings surrounded by quotes and separated by commas.
Each row will start on a new line. Close Calc.
Open the .csv file in a text editor (or Writer) and change all the
quotes to nulls (the empty string - *nothing* in the "replace with"
box). Save the result as another .csv file (or overwrite the original if
you are brave enough).
Import the result into Calc.
Done.
--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]