Hi,
insert a column and enter the formula

=trim(A1)
copy it down, then copy and paste as values , then format as number

trim will eliminate any blank space

"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?