ExcelBanter - formating number with place holder

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formating number with place holder (https://www.excelbanter.com/excel-discussion-misc-queries/216528-formating-number-place-holder.html)

Royce

formating number with place holder

I have numbers on sheet some single digit and some 2-digit. I am trying to
autoformat so that all the single digit have a 0 precursor.

Ex.

1 would yield 01
but
12 would only yield 12

David Biddulph[_2_]

formating number with place holder

Format as 00
--
David Biddulph

"Royce" wrote in message
...
I have numbers on sheet some single digit and some 2-digit. I am trying to
autoformat so that all the single digit have a 0 precursor.

Ex.

1 would yield 01
but
12 would only yield 12

Roger Govier[_3_]

formating number with place holder

Hi

FormatCellsNumberCustom00

--
Regards
Roger Govier

"Royce" wrote in message
...
I have numbers on sheet some single digit and some 2-digit. I am trying
to
autoformat so that all the single digit have a 0 precursor.

Ex.

1 would yield 01
but
12 would only yield 12

Bob Phillips[_3_]

formating number with place holder

Just use a custom format of "00" (without quotes)

--
__________________________________
HTH

Bob

"Royce" wrote in message
...
I have numbers on sheet some single digit and some 2-digit. I am trying to
autoformat so that all the single digit have a 0 precursor.

Ex.

1 would yield 01
but
12 would only yield 12

All times are GMT +1. The time now is 06:53 AM.