At 10:57 11/12/2007 +1100, Pierre Noname 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?
You have apparently already solved this, but there is an alternative
way that works within the spreadsheet itself:
o Somewhere convenient elsewhere on the sheet (or perhaps most
conveniently on another sheet), enter the formula
=VALUE(A1)
to refer to one cell of your data.
o Drag this cell to fill an area matching the data with
corresponding formulae. You now have your numeric values, but in the
wrong place.
o Select the new values and copy them.
o Select the top-left corner cell of your original data area and
paste the new values over the old. But instead of using Paste, use
Edit | Paste Special... (or right-click | Paste Special... or
Ctrl+Shift+V). In the Paste Special dialogue, remove the tick from
"Paste all" if necessary, and then ensure that Numbers is ticked but
Formulas is *not* ticked.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
