Data with leading zeros

  • Thread starter Thread starter sheddhead
  • Start date Start date
S

sheddhead

We pull data into Excel that has the following format -

#####

We want to do two things with this data. First, we want
to add 2 0's before the last #. ####00#.

Second, we want Excel to recognize - not suppress leading
0's on the number. So, if 0#### were entered, the display
and the formula bar would both show: 0###00#.

How would I customize the numbers for these cells, to get
this display? Thanks!!!!
 
See if this works:

=REPLACE(IF(LEN(A1)=5,A1,REPT(0,5-LEN(A1))&A1),4,,"00")

HTH
Jason
Atlanta, GA
 
Back
Top