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