Numbers
 

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

Numbers
 

select list and run this kode

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



"juanpablo" skrev:

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

Numbers
 

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"juanpablo" wrote in message ...
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

Numbers
 

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


"juanpablo" wrote:

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

Numbers
 

Thanks!

"Teethless mama" wrote:

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


"juanpablo" wrote:

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