Format Cell After Cell Has Contents

[farrreaching]

I have a Column of cells which were formated as Text and now needs to be Number. In order for the cells to now reflect a proper number, the cell needs to be edited or updated. How can I update 2000 cells without double-clicking each one?

 

[Dreamboat]

Sure.

I call it the Times One Fix.

Put a 1 in any cell.
Copy that cell.
Select ALL *bad* cells.
Hit Edit-Paste special, choose Multiply and Ok.

Follow those directions exactly, and you'll have it in just a few seconds. Anne Troy
Dreamboat@TheWordExpert.com
Anne@MrExcel.com

 

[iGrant]

Or as an alternative, put the formula

=Value(A1)

in B1 (assuming your list starts in A1) and copy down the length of your column of numbers.

Then copy the results in B1 to B2000 (or whatever) and Paste Special - Values back onto A1.