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

     

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