View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brent E Brent E is offline
external usenet poster
 
Posts: 74
Default Leading 0s and Col Formatting

I've got an Excel workbook that contains many license numbers and I need to
format the column so that if a license number has several 0s in front, they
aren't automatically truncated by Excel. I tried general, number, and text
formats but they truncate leading 0s. Any ideas? Thanks.