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

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?