Remove Zeros

[dhasa]

Hi,

How do I remove the leading zeros in a column?

For example. In the file, the zeros should be deleted permanently and shown as blank cell. Please refer attchment.

[kersplash]

Try this in C2 and copy down;

Please Login or Register  to view this content.

[samba_ravi]

Select the Cells
> Press Ctrl+H
> enter 0 in Find what place
> leave replace with as blank
> Select Match entire cell Content
> if you are unable to find "Match entire cell Content" click on Options button to find Match entire cell Content
> Click on ReplaceAll
> Click on Close

[dhasa]

thanks nflsales