Padding 0's

New 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:
Hi there,

Couldn't seem to get this formula to work, do you know of any others?

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



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies