how can a two digit # be set up with 2 0's at the beginning 0025

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I set up my spreadsheet with one column that will have a four place
number (0000) or if a number is 25 will put two zeros in front of that
number.

Example: 0025
or 0000
or 0045
The column would change the numbers to 0000 if a number is not there or if a
two digit number is there it would change the cell to two zeros in front of
the two digit number 0045.
 
Format....cells....custom, choose any type and in the box just below type:
enter 0000
 
Linda/tim

I'm still trying to figure out how to format to get 0000 if no number in the
cell.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

How do you change single digits to recognized double digits? 6
I think it's an IF function but I am not sure 3
Two digit number with one decimal, or three digit number 2
Leading Zeros; How to Keep ? 2
Adding a zero to the front of numbers 5
How can I keep a zero (0) at the front of a set of numbers. 2
Converting a cell value 4
Barcode Check Digits 3

Back
Top