4 Digits
 

I'm trying to formulate a column into 4 digits. So if I were to type
in 25 and hit enter it would show as 0025. Can anyone help me figure
out how to do this? Thanks!

4 Digits
 

Use custom format 0000


--
Regards,

Peo Sjoblom



wrote in message
oups.com...
I'm trying to formulate a column into 4 digits. So if I were to type
in 25 and hit enter it would show as 0025. Can anyone help me figure
out how to do this? Thanks!

4 Digits
 

Highlight the cells you want to display this way. Right-click on the select
cells-Format Cells. Under the Number tab, select Custom. Set the custom
format to 0000.

HTH,
Paul

wrote in message
oups.com...
I'm trying to formulate a column into 4 digits. So if I were to type
in 25 and hit enter it would show as 0025. Can anyone help me figure
out how to do this? Thanks!

4 Digits
 

Hi,

Use a custom format of

0000

Mike

" wrote:

I'm trying to formulate a column into 4 digits. So if I were to type
in 25 and hit enter it would show as 0025. Can anyone help me figure
out how to do this? Thanks!

4 Digits
 

FormatCellsNumber TabCustom Format of 0000


Gord Dibben MS Excel MVP

On Thu, 28 Jun 2007 11:35:43 -0700, wrote:

I'm trying to formulate a column into 4 digits. So if I were to type
in 25 and hit enter it would show as 0025. Can anyone help me figure
out how to do this? Thanks!