View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christine Christine is offline
external usenet poster
 
Posts: 147
Default 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