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