Forum Discussion
Max_B1
May 20, 2019Copper Contributor
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
Sort By
- TwifooSilver ContributorIf the number is in A1, you can try this formula in B1:
=“FB”&TEXT(A1,”0000”)- Max_B1Copper ContributorHi there,
Couldn't seem to get this formula to work, do you know of any others?- SergeiBaklanDiamond Contributor