Numbers

J

juanpablo

Hi,

Sometimes, when I import databases, the numbers are not recognized and I
have to manually convert to number, using the 'autocorrect' tab by each one.
Is there a faster way to change them all at once?

Thanks

JP
 
E

excelent

select list and run this kode

Sub Convert()
For Each x In Selection
x = CDec(x)
Next
End Sub



"juanpablo" skrev:
 
D

David McRitchie

Hi Juan,
To correct what you have,
format the cells as General or to a desired number format,
then use the TrimAll macro to reenter content of cells in
selection.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

If you don't want to use macros yet then you can try
select a cell that is empty (never used) and copy it (Ctrl+C)
then select the cells to be converted and use
Edit, Paste Special, Add, Ok
when finished hit Esc to remove the "marching ants" around
the original selection.
 
T

Teethless mama

Copy a blank cell > highlight your range > right click Paste Special > Add > OK
 
Top