Trim leading zeros

[Guest]

How do I trim leading zeros from a cells?

000000023
000000003
000000010

Thanks!

 

[Frank Kabel]

Hi
one way:
- format the cells with a number format
- select an empty cell and copy this cell
- select your range of data
- goto 'Edit - Paste Special' and choose 'Add'

 

[sulprobil]

If your data is in column A and if you only have integers,
type in cell B1: =TEXT(VALUE(A1),"0") and copy this down
(if you need text, if you need values, omit the text
function).

Regards,
sulprobil