Problem with auto correction in cells

[hauchr]

When I type ex. 0771 in a cell, excel auto change it to 771.
How do I avoid this

 

[Frank Kabel]

Hi
if you need a leading zero you have some options:
1. If you don't need to calculate with these values either
preformat the cell as 'Text' or enter the value with a
leading apostrophe

2. If you need these values as numbers you may apply a
custom format to these cells. In your case for example the
custom format
0000