How to remove leading zeros from a number in a cell
Solved
Marie Chantal
-
Nina -
Nina -
Hello,
I have a column where some numbers start with two zeros, others with three zeros or one zero.
Example:
A1 00616550
A2 00085970
A3 31250366
A4 06156700
I would like to remove the leading zeros from the numbers. How should I do this?
Thank you very much for getting back to me as soon as possible.
Marie Chantal
Configuration: Windows 7 / Internet Explorer 9.0
I have a column where some numbers start with two zeros, others with three zeros or one zero.
Example:
A1 00616550
A2 00085970
A3 31250366
A4 06156700
I would like to remove the leading zeros from the numbers. How should I do this?
Thank you very much for getting back to me as soon as possible.
Marie Chantal
Configuration: Windows 7 / Internet Explorer 9.0
7 réponses
Hello,
If you don’t have a cell format that enforces this display, it’s text.
To convert to numeric:
- copy an empty cell
- select the range (column)
- special paste 'add'
Eric
--
By continually trying, you eventually succeed.
So the more it fails, the more chances you have that it will work. (Shadok motto)
In addition to saying thank you (yes, it’s a thing!!!), remember to mark it as resolved. Thanks
If you don’t have a cell format that enforces this display, it’s text.
To convert to numeric:
- copy an empty cell
- select the range (column)
- special paste 'add'
Eric
--
By continually trying, you eventually succeed.
So the more it fails, the more chances you have that it will work. (Shadok motto)
In addition to saying thank you (yes, it’s a thing!!!), remember to mark it as resolved. Thanks
Thank you Eric. Your tip was helpful to me.
Ça fonctionne parfaitement. Merci Eric