Converting "special data" into number in the same column
 

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?

Converting "special data" into number in the same column
 

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!
================================================== ===

"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?

Converting "special data" into number in the same column
 

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....

"RagDyeR" wrote:

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!
================================================== ===

"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?

Converting "special data" into number in the same column
 

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?

Converting "special data" into number in the same column
 

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

Regards,

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

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

"RagDyeR" wrote:

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!
================================================== ===

"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?