Format Cell-Change

[Sunil Pinto]

Dear MS-Excel Forums,



Please help me to solve this problem.

I had the text data in excel having around 1000 rows of number. Say for example bank account number.

Some of the number are starting with natural numbers, but many numbers are starting with zero's, it may be staring with one or many zeros.(Example 023829, 00382741,128407439)
If your number is start with zeros than top-left side of the cell is prompting you to convert the format of the cell as number. Accidently I converted as number and saved.

Now the problem, I want to get the numbers with zero's back. I would have tried by using functions, if I had my previous data of certain digits (say for example my previous data digits are fixed for 8 only) But this case my data contains different number digits.

Is there any way out to get the previous data back. Other side data which typed is manually, (let Microsoft can change the formatting which ever we opted. But should not allowed to change the base data which we typed-Hope this should be the basic principle)

Please let me know you have any way get back this data


Thanks & Regards,

Sunil Pinto.