Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing Original Cell Format when pasting in cells | Excel Discussion (Misc queries) | |||
Why will my cells not format? | New Users to Excel | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
format cells having text | Excel Discussion (Misc queries) |