Decimal

Copper Contributor

Good morning,
if I had multiple lines with numbers like:
0896
0967
0678
I wanted to know, since I have a list of 900 pieces, if it is possible to express only the numbers after 0.
ie:
896
967
678
Thanks in advance

 

Best Regards,

Riccardo Leggi

1 Reply

@rleggi Your "numbers" with leading zeros ar in fact texts. You can convert them to numbers like in the formula below and copy it down (assuming your first "number" is in A1.

=--A1

 or,

=VALUE(A1)

if you prefer a more traditional formula.