Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
converting data - re-formating data to "date" format | Excel Discussion (Misc queries) | |||
copy--paste--special "formula" for a whole column | Excel Discussion (Misc queries) | |||
How do I remove "special characters" from cell data? | Excel Discussion (Misc queries) | |||
Change data in a single column from "last, first" to "first last" | Excel Discussion (Misc queries) |