I have a column of numbers, as below. How can I remove the 0 in front? 035000 035002 035006 035009
K Kipurr Sep 25, 2008 #1 I have a column of numbers, as below. How can I remove the 0 in front? 035000 035002 035006 035009
P Peo Sjoblom Sep 25, 2008 #2 Format as general or as number without any decimals. If they still look the same they must be text or have invisible characters. -- Regards, Peo Sjoblom
Format as general or as number without any decimals. If they still look the same they must be text or have invisible characters. -- Regards, Peo Sjoblom
D David McRitchie Sep 25, 2008 #3 After specifying the format as number you have to activate them so you would have to activate them as reentries. One way would be to select an empty cell then select the cells you need to convert, then right click, then Paste Special, then Add That is better than multiplying by 1 as it will not damage empty cells. For more information see Number Conversions http://www.mvps.org/dmcritchie/excel/numconv.htm
After specifying the format as number you have to activate them so you would have to activate them as reentries. One way would be to select an empty cell then select the cells you need to convert, then right click, then Paste Special, then Add That is better than multiplying by 1 as it will not damage empty cells. For more information see Number Conversions http://www.mvps.org/dmcritchie/excel/numconv.htm
U Uma Nandan Sep 26, 2008 #4 Hi, You can also try Text to column - Fixed width. To delete the Zeros from entire row. Regards,
