Excel number formatting

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

I receive spreadsheets with separate columns of numbers
and text. The problem is that the numbers column is not in
number or general format (when sorting behaves like text).
Is there a way to turn those columns into numbers (except
stepping into each one separately)? When I just highlight
the number in the cell and hit enter, the cell
automatically becomes numeric (I'm looking for a more
global solution).
Thanks, A
 
You can do this:

1. Type 1 (the number 1) into a blank cell. Highlight this, select Edit,
Copy. Now highlight entire column(s) that you want changed to numeric, and
select Edit, Paste Special, Multiply, click OK.

MRO
 
Back
Top