SOLVED

Padding 0's

Copper Contributor

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
If the number is in A1, you can try this formula in B1:
=“FB”&TEXT(A1,”0000”)
Hi there,

Couldn't seem to get this formula to work, do you know of any others?
best response confirmed by Max_B1 (Copper Contributor)
Solution

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

image.png

 

1 best response

Accepted Solutions
best response confirmed by Max_B1 (Copper Contributor)
Solution

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

image.png

 

View solution in original post