SOLVED
Home

Padding 0's

Max_B1
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:
=“FB”&TEXT(A1,”0000”)
Hi there,

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

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

image.png

 

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