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 1 and need to be in the following format FB0001, I have worked out how to add the leading zeros but have been unsuccessful in adding the FB without corrupting the format. 

 

Any support would be fantastic!

 

3 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    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
      Hi there,

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

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

         

Resources