View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Automatic prefix set with leading zeros Automatic prefix set with leading zeros is offline
external usenet poster
 
Posts: 1
Default automatically prefix cell entry with leading zeros

Hi,

I am trying to setup a prefix where I have a set number starting out but
need to add additional numbers..

I have the format down to do that but is there a way to keep the leading
zeros displayed since some of the numbers I have start with zeros...

Example 123 is the set number and i want to add 00456...

correct result 123456