Deleting zeros

Mar 6th, 2002, 09:14 PM

Hello people
I have a column contains some number which start with 0
eg.
0123
022
033
123
33
How can I delete those zeros?
Thanks in advance

Dave Hawley · Mar 6th, 2002, 10:45 PM

Hi

You could use Edit>Replace but this would also delete zeros in any position. Use this function instead:

=SUBSTITUTE(A1,"0","")*1

It will result in a real number.

Mark W. · Mar 7th, 2002, 07:32 AM

It appears that you have a column of text representations of numbers (e.g., "033"). If you wish to convert these to numeric values select 'em, choose the Data | Text to Columns... menu command and press [ Finish ].

Mar 7th, 2002, 07:56 AM

That's so easy and quick
Thanks alot Mark

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 09:14 PM	#1
Guest Posts: n/a	Hello people I have a column contains some number which start with 0 eg. 0123 022 033 123 33 How can I delete those zeros? Thanks in advance

Mar 6th, 2002, 10:45 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi You could use Edit>Replace but this would also delete zeros in any position. Use this function instead: =SUBSTITUTE(A1,"0","")*1 It will result in a real number.

Mar 7th, 2002, 07:32 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	It appears that you have a column of text representations of numbers (e.g., "033"). If you wish to convert these to numeric values select 'em, choose the Data \| Text to Columns... menu command and press [ Finish ].

Mar 7th, 2002, 07:56 AM	#4
Guest Posts: n/a	That's so easy and quick Thanks alot Mark