How do I display the number 007? It keeps changing to 7

A

Amy

I need to have zeros in front of my numbers, but the worksheet keeps removing
the zeros. I need it to display 007, 042. etc
 
C

CLR

One way is to type an apostrophe before the first zero......it won't show,
but changes the value to TEXT and displays the leading zeros..........

Vaya con Dios,
Chuck, CABGx3
 
G

Gord Dibben

Methods......

1. Enter an apostrophe before typing the number.

2. Pre-format the cells as Text before entry.

3. Use a Custom Format of 000

The first two will be text and not calculable.

The third will not change the value of the numbers, formatting only.


Gord Dibben Excel MVP
 
Top