I am setting up a workbook where I would like to label series of vinyl
windows starting at 01, 02, 03 etc.

How do I do this? It keeps reverting back to 1, 2, 3.

TIA,

Eric

you should be able to go to format cells, click custom and enter 00 under
type

then format the cells with that.
--


Gary


"ecm" wrote in message
news:p7a4f.27476$S4.23411@edtnps84...
I am setting up a workbook where I would like to label series of vinyl
windows starting at 01, 02, 03 etc.

How do I do this? It keeps reverting back to 1, 2, 3.

TIA,

Eric

Eric

Either preface the numbers with an apostrophe or format as Custom with an
appropriate number of 0's depending upon how far your list will extend.


Gord Dibben Excel MVP

On Sat, 15 Oct 2005 16:29:09 GMT, "ecm" wrote:

I am setting up a workbook where I would like to label series of vinyl
windows starting at 01, 02, 03 etc.

How do I do this? It keeps reverting back to 1, 2, 3.

TIA,

Eric

enter

'01
'02

instead of 01, 02

the single quote tells excel to treat the entry as text and it won't remove
the leading zero.

An alternative is to format=Cell=Number tab, then select custom and enter
00

--
Regards,
Tom Ogilvy

"ecm" wrote in message
news:p7a4f.27476$S4.23411@edtnps84...
I am setting up a workbook where I would like to label series of vinyl
windows starting at 01, 02, 03 etc.

How do I do this? It keeps reverting back to 1, 2, 3.

TIA,

Eric

Great.

When I went into Custom - it doesn't show 00.
I was able to enter it - and it worked fine.
Should this selection be under Custom menu?

Thanks for all your help guys.

Eric

"ecm" wrote in message
news:p7a4f.27476$S4.23411@edtnps84...
I am setting up a workbook where I would like to label series of vinyl
windows starting at 01, 02, 03 etc.

How do I do this? It keeps reverting back to 1, 2, 3.

TIA,

Eric

Eric

00 is not a default selection under "Custom".

i.e. you would have to enter it for each workbook.

It will be saved with the workbook, however.


Gord


On Sat, 15 Oct 2005 17:08:13 GMT, "ecm" wrote:

Great.

When I went into Custom - it doesn't show 00.
I was able to enter it - and it worked fine.
Should this selection be under Custom menu?

Thanks for all your help guys.

Eric

"ecm" wrote in message
news:p7a4f.27476$S4.23411@edtnps84...
I am setting up a workbook where I would like to label series of vinyl
windows starting at 01, 02, 03 etc.

How do I do this? It keeps reverting back to 1, 2, 3.

TIA,

Eric

No. While custom has some default offerings, it is largely for putting in
your custom format.

--
Regards,
Tom Ogilvy

"ecm" wrote in message
news:1Ia4f.27772$S4.26492@edtnps84...
Great.

When I went into Custom - it doesn't show 00.
I was able to enter it - and it worked fine.
Should this selection be under Custom menu?

Thanks for all your help guys.

Eric

"ecm" wrote in message
news:p7a4f.27476$S4.23411@edtnps84...
I am setting up a workbook where I would like to label series of vinyl
windows starting at 01, 02, 03 etc.

How do I do this? It keeps reverting back to 1, 2, 3.

TIA,

Eric

you can also format the cells as text;
Format - Cells - Text

you can also format the cells as text;
Format - Cells - Text

you can also format the cells as text;
Format - Cells - Text