View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Format as number of general, copy an empty cell, select all data and do
editpaste special and select add


Regards,

Peo Sjoblom

"yahoo" wrote:

Hi

I have a column of numbers in text format - I need to change them to
number format

When I goto Format -cells to change - it does not work
Is there another way to change?

Thanks