Thread: In Excel find 5 digit number and replace with leading zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default In Excel find 5 digit number and replace with leading zero
Hi,

Apply a custom format of 000000 that's 6 zeroes

Mike

"CDPalmer" wrote:

I have a column of 5 digit numbers which I would like to replace with the
same number with a leading zero.
--
CDP
Reply With QuoteReply With Quote