SOLVED
Home

Padding 0's

%3CLINGO-SUB%20id%3D%22lingo-sub-615595%22%20slang%3D%22en-US%22%3EPadding%200's%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615595%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20need%20of%20some%20help.%20I%20have%20a%20spreadsheet%20that%20contains%20a%20set%20of%20data%2C%20however%20due%20to%20different%20sources%20of%20information%20not%20all%20of%20the%20cells%20are%20in%20the%20same%20format.%20The%20cells%20start%20at%201%20and%20need%20to%20be%20in%20the%20following%20format%20FB0001%2C%20I%20have%20worked%20out%20how%20to%20add%20the%20leading%20zeros%20but%20have%20been%20unsuccessful%20in%20adding%20the%20FB%20without%20corrupting%20the%20format.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20support%20would%20be%20fantastic!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-615595%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-615623%22%20slang%3D%22en-US%22%3ERe%3A%20Padding%200's%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615623%22%20slang%3D%22en-US%22%3EIf%20the%20number%20is%20in%20A1%2C%20you%20can%20try%20this%20formula%20in%20B1%3A%3CBR%20%2F%3E%3D%E2%80%9CFB%E2%80%9D%26amp%3BTEXT(A1%2C%E2%80%9D0000%E2%80%9D)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-615688%22%20slang%3D%22en-US%22%3ERe%3A%20Padding%200's%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615688%22%20slang%3D%22en-US%22%3EHi%20there%2C%3CBR%20%2F%3E%3CBR%20%2F%3ECouldn't%20seem%20to%20get%20this%20formula%20to%20work%2C%20do%20you%20know%20of%20any%20others%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-615812%22%20slang%3D%22en-US%22%3ERe%3A%20Padding%200's%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615812%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F345021%22%20target%3D%22_blank%22%3E%40Max_B1%3C%2FA%3E%26nbsp%3B%2C%20you%20may%20apply%20custom%20number%20format%20%22FB%220000%20to%20the%20series%20of%20integer%20numbers%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20365px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114375iE8ECE278905A68D9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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