You might try copying an empty cell, then selecting your column of "numbers"
and using Edit/ Paste Special/ Add
An alternative approach is to try Data/ Text to Columns
You might find that your cells contain spaces, or non-breaking spaces or
other non-numeric characters, so you might try a SUBSTITUTE or REPLACE
operation.
--
David Biddulph

"Bzltyr" wrote in message
...
I have a column of numbers that are formatted as text. I can change the
format to number but the value does not change. What is the shortcut for
rentering the value that is currently in the cell?