Forum Discussion

Max_B1's avatar
Max_B1
Copper Contributor
May 20, 2019
Solved

Padding 0's

Hi there,    In need of some help. I have a spreadsheet that contains a set of data, however due to different sources of information not all of the cells are in the same format. The cells start at ...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    May 20, 2019

    Max_B1 , you may apply custom number format "FB"0000 to the series of integer numbers

     

Twifoo's avatar
Twifoo
Silver Contributor
May 20, 2019
If the number is in A1, you can try this formula in B1:
=“FB”&TEXT(A1,”0000”)
  • Max_B1's avatar
    Max_B1
    Copper Contributor
    May 20, 2019
    Hi there,

    Couldn't seem to get this formula to work, do you know of any others?
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 20, 2019

      Max_B1 , you may apply custom number format "FB"0000 to the series of integer numbers

       

Resources