Format cells to always have 13 digits?

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

Guest

This may be here somewhere but I must be searching for the wrong words. If
it's a duplicate, I apologize.

I need every cell within a column to always contain 13 digits. For instance,
if the cell is 12345678, I want it to add preceeding zero's and have it read
0000012345678, and it still needs to be a number.

Any suggestions?

Christine
 
Christine,

Quickest and Easiest. Just go to format>cells and select "custom" enter 13
zeros as your format for that column and you're done.
 
Thanks so much.

JC said:
Christine,

Quickest and Easiest. Just go to format>cells and select "custom" enter 13
zeros as your format for that column and you're done.
Click to expand...
 

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

Adding recognised Zeros 5
How to validate a cell to insert from 9 digit number to 13 digit number. 1
How to validate a cell to insert from 9 digit number to 13 digit number. 1
Formula for every 13 cells 4
Cell will not format numbers correctly for a 13 digit custom barc. 4
enetering fed ex tracking # in cell 2
How do you change single digits to recognized double digits? 6
using the =page! feature to transpose a row to column 0

Back
Top