Format cells to always have 13 digits?
 

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

Format cells to always have 13 digits?
 

Christine,

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


"Christine" wrote:

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

Format cells to always have 13 digits?
 

Thanks so much.

"JC" wrote:

Christine,

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


"Christine" wrote:

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