I want to be able to see a number with a zero in front of it as in 019, no
decimals or anything but everytime I enter it and move to the next cell the 0
automatically disappears. Can anyone help?
I want to be able to see a number with a zero in front of it as in 019, no
decimals or anything but everytime I enter it and move to the next cell the 0
automatically disappears. Can anyone help?
Lauren -
You'll have to format the cell as "Text" to make it work.
Hope this helps,
Carole O
"lauren" wrote:
> I want to be able to see a number with a zero in front of it as in 019, no
> decimals or anything but everytime I enter it and move to the next cell the 0
> automatically disappears. Can anyone help?
Or, you can precede your value with a single quote...
'019
Hope this helps!
In article <[email protected]>,
lauren <[email protected]> wrote:
> I want to be able to see a number with a zero in front of it as in 019, no
> decimals or anything but everytime I enter it and move to the next cell the 0
> automatically disappears. Can anyone help?
Right click on the cell, choose the "Number" tab. Within
the category field, choose text.
That should help
>-----Original Message-----
>I want to be able to see a number with a zero in front of
it as in 019, no
>decimals or anything but everytime I enter it and move to
the next cell the 0
>automatically disappears. Can anyone help?
>.
>
Lauren
In addition to the other posts.....
Enter 19 and Custom Format as 000.\
It will look like 019 but still be the number 19 if you need it for
calculations.
Gord Dibben Excel MVP
On Tue, 8 Mar 2005 11:23:10 -0800, lauren <[email protected]>
wrote:
>I want to be able to see a number with a zero in front of it as in 019, no
>decimals or anything but everytime I enter it and move to the next cell the 0
>automatically disappears. Can anyone help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks