Problem with auto correction in cells

  • Thread starter Thread starter hauchr
  • Start date Start date
H

hauchr

When I type ex. 0771 in a cell, excel auto change it to 771.
How do I avoid this
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fill not working 2
Wisdom of a 771/775 LGA adapter 1
SUMPRODUCT COUNT DATE 8
AUTO CORRECT PROBLEM 2
The next Grand Theft Auto title has been officially announced 0
Excel Auto correct 4
Last Modified By in a cell by user 3
Calculate (Auto Fill) cells with numbers and text. 3

Back
Top