formating number with place holder

  • Thread starter Thread starter Royce
  • Start date Start date
R

Royce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autoformat/Conditional Format of entered Number 2
formatted to place dashes within numbers formatted as text 1
Custom number format #,##0.## yields extra '.' when formattingintegers 3
script or format to identify duplicate data 2
Extract number from text string based on number's format? 16
How do I get a column with 12 digit numbers to only show the 1st 1 1
format cell with multiple formats for telephone numbers 1
Loop 1

Back
Top