Hi,

You can also try the following. Type 1 in any cell and copy it. After that
select the range of imported numbers and Edit Paste Special Multiply

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"PaulinaDi" wrote in message
...
Hello. As one of my last questions, as I get some info from an internal
program, I have to work it in Excel and it's a little crazy to convert
each
month several columns to the correct format.
You have helped me with the date format but now I remember I have the same
problem with numbers.
I get a column with numbers like 11,000.00 but not treated as number but
as
text so I'm not able to sumarize that column.
What I do, always, is entering a simple formula in another column like
e.g.
=C5*1 and then I get the number as it is, so I return the value to the
original column and then I may use it for the future.
I have found that the problem is because of the comma in the original
number
as it is treated as text.
Is there any way to convert text into number IN THE SAME COLUMN in an easy
step in order to make my job faster each month?