viewing/ input
 

how can i input numbers "00147"? i always get 147
please guide me.

viewing/ input
 

If you alwasy want 5 digits with enough leading zeros, then pull-down:

Format Cells... Number Custom

and enter 00000 in place of General
--
Gary's Student


"Emman" wrote:

how can i input numbers "00147"? i always get 147
please guide me.

viewing/ input
 

Emman,

Try to go to menu Format - chose cells. On tab number, chose category
text.
Input your 00147, and it will stay in that format.

Hope it will help you!


--
Svea
------------------------------------------------------------------------
Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151
View this thread: http://www.excelforum.com/showthread...hreadid=480335

viewing/ input
 

put an apostrophe ' in front of the number is another way of doing it

--
Natalie


"Emman" wrote:

how can i input numbers "00147"? i always get 147
please guide me.

viewing/ input
 

"Svea" wrote:


Emman,

Try to go to menu Format - chose cells. On tab number, chose category
text.
Input your 00147, and it will stay in that format.

Hope it will help you!


--
Svea
------------------------------------------------------------------------
Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151
View this thread: http://www.excelforum.com/showthread...hreadid=480335

thank you

viewing/ input
 

"Gary''s Student" wrote:

If you alwasy want 5 digits with enough leading zeros, then pull-down:

Format Cells... Number Custom

and enter 00000 in place of General
--
Gary's Student
thank you

"Emman" wrote:

how can i input numbers "00147"? i always get 147
please guide me.

viewing/ input
 

"Natalie" wrote:

put an apostrophe ' in front of the number is another way of doing it

--
Natalie


"Emman" wrote:

how can i input numbers "00147"? i always get 147
please guide me.

Thank you you all are helpful