dropping number

  • Thread starter Thread starter amy
  • Start date Start date
A

amy

When I type 020627 excel puts in 20627 it always drops
the zero. I have tried differnet formats... what am I
doing wrong? thanks
 
Hi

Either format the cell as text before you enter the data, or type an
apostrophe ' first - which will tell Excel it is text.
 
Format,
Cell,
Custom,
and in the 'type' box enter 000000

BOL, Dave Moore
 
If you still want the number functionality for operations
and so forth do...

Format > Cells > Custom > 000000

That is if you will always type a 6 digit number...

Cheers
Juan
 
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

Can someone help me please? Prefix to add international diallingcodes to Uk mobile numbers 1
Alt codes 4
PowerPoint High Resolution Images from PowerPoint 0
Formatted cell column in drop down list 1
Editing a cell in Excel spreadsheet 2
Created invoices in Excel - not working in Drive 1
=IF(NOT(ISNA(VLOOKUP Function 2
How to prevent leading zero's from being dropped from a CSV file 1

Back
Top