Deleting zeros

[Guest]

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]

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.]

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 ].

 

[Guest]

That's so easy and quick
Thanks alot Mark