View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mustafa
 
Posts: n/a
Default HOW TO ZERO FILL A CELL THAT CONTAINS OTHER DATA EX. 000123?

I hope this may help;
Just open the cell's format, choose the "Number" tab, under the category
choose "Custom", then in the "Type" box write the 15 zeros.
"Type:"
000000000000000
this will do it i hope
--
Keep the Hope


"Mike B" wrote:

I need to fill cells 15 charecters in length with zeroes, the cells have
numbers in them already, ex. 45678 needs to read 000000000045678. The numers
in the cells are not the same length, some are 4 charecters up to 7
charechters. Can this be done?