How do I change auto formatting to allow a 0 as the first number

D

Dave Peterson

I'm not sure what auto formatting is, but you can either change the numberformat
to a custom format (like: 00000), then do your data entry.

Or you can prefix your entry with an apostrophe: '01234

Or you could preformat the cell as Text and it'll keep anything you type as-is.

britlynd wrote:
 

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

how to get left side zeros to show i.e. 00045 0
how to insert symbol or sign on the top right of any number 2
how to put a number with more than 15 digits in a cell 0
How do I format cells to show the number 0 as first number in seri 3
Adding an apostrophe to a column of numbers 5
How do I create a set of words that are flagged? 0
How do I allow a cell to display a 0 as the first digit 1
Snag in invoice generator. How to change the "series" 5

Top