Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Invereted Commas
I have a column of data with invereted commas. ex- "123456". I need to remove
these inverted commas and make the number 123456. Any Help Pls ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Invereted Commas
"Rumy" wrote:
I have a column of data with invereted commas. ex- "123456". I need to remove these inverted commas and make the number 123456. By "inverted commas", are you referring to the (double) quotes? I think you are asking: how do you change a column of numeric strings entered as text into bona fide numbers. In Excel 2003, perhaps the simplest way is: select the column or the range of cells, then click on Data Text to Columns. Caveat.... If some of those numeric strings have leading zeros, you will "lose" the leading zeros when you convert to a number. You can "restore" them by using a custom format; for example, 0000 for a 4-digit number. But in that case, the question is: why are you converting to number in the first place? Numeric strings with leading zeros usually represent identification codes. They should be treated as text, not numbers. Only convert numeric strings to number if you need to perform arithmetic operations on them. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Invereted Commas
On dec. 31, 17:30, Rumy wrote:
I have a column of data with invereted commas. ex- "123456". I need to remove these inverted commas and make the number 123456. Any Help Pls ? Select the column! EditReplaceEnter " in From, nothing in To Click Replace all Regards, Stefi |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Invereted Commas
Thank You Sir. Ya i have to convert to do some mathematical functions. Wish
you a Happy New Year !!! "Joe User" wrote: "Rumy" wrote: I have a column of data with invereted commas. ex- "123456". I need to remove these inverted commas and make the number 123456. By "inverted commas", are you referring to the (double) quotes? I think you are asking: how do you change a column of numeric strings entered as text into bona fide numbers. In Excel 2003, perhaps the simplest way is: select the column or the range of cells, then click on Data Text to Columns. Caveat.... If some of those numeric strings have leading zeros, you will "lose" the leading zeros when you convert to a number. You can "restore" them by using a custom format; for example, 0000 for a 4-digit number. But in that case, the question is: why are you converting to number in the first place? Numeric strings with leading zeros usually represent identification codes. They should be treated as text, not numbers. Only convert numeric strings to number if you need to perform arithmetic operations on them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Do I Add Commas To Columns And Remove Spaces In Excel?? | Excel Discussion (Misc queries) | |||
So many commas | Excel Worksheet Functions | |||
commas in cells | Excel Discussion (Misc queries) | |||
How to remove commas from a downloaded .dat file? | Excel Worksheet Functions | |||
Missing commas | Excel Worksheet Functions |