Hi Pierre,
Assuming that the numbers are in column A, enter the formula
=value(a1)
into the top cell of an empty column and fill down. Copy the results and paste
special into column A, with 'formulas' unchecked.
tc
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
