Converting "special data" into number in the same column

[PaulinaDi]

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?

 

[RagDyeR]

Select the values in the column, and then simply open and close TTC.

Select the column, then, from the Menu Bar,
<Data> <Text To Columns> <Finish>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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?

 

[PaulinaDi]

UPS. Very easy. I supposed I had to follow up all the steps. That's why I
didn´t get nothing good anytime before.
Thanks a lot! It was very very easy....

 

[Ashish Mathur]

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

 

[RagDyeR]

You're welcome, and appreciate the feed-back.