Issues of reading zero in excel
Posted on 2012-03-30
I have data sheet which contains alphabets and numbers in every cell. I want to delete all the alphabets from the cell and just want numbers.
My difficulty is, when I try to remove the alphabets; the zero vanishes!
Please refer the example below:
ABC0123456 (Original Data in the software)
When I try to remove 'ABC' from the cell,
It shows 123456 (The 0 is not there!)