One way is to copy a blank cell. Select the column of numbers and right
clickPasteSpecialAdd..OK.

Another if error checking is enabled ;;select the column. Within the
selection the active cell should contain a number formatted as text. If you
notice a light yellow colored box appearing to the left side (with a green
triangle on the left top corner of the cell)..Click on the yellow box
(exclamation mark) and select convert to number.

If this post helps click Yes
---------------
Jacob Skaria


"Bzltyr" wrote:

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?