Custom number formatting - same text before changing numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-2799346%22%20slang%3D%22en-US%22%3ECustom%20number%20formatting%20-%20same%20text%20before%20changing%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2799346%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20custom%20formatting%20option%20do%20I%20have%20to%20pick%20in%20order%20to%20have%20the%20same%20text%20appear%20before%20different%20numbers%3F%20For%20example%2C%20I'm%20trying%20to%20have%20cells%20in%20consecutive%20rows%20show%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECustomer%201%3C%2FP%3E%3CP%3ECustomer%202%3C%2FP%3E%3CP%3ECustomer%203%2C%20so%20on%20and%20so%20forth%20but%20just%20want%20to%20be%20able%20to%20add%20%22A1%20%2B%201%22%20and%20drag%20it%20down%20so%20that%20%22Customer%22%20automatically%20populates%20in%20front%20of%20each%20number.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2799346%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2799791%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20number%20formatting%20-%20same%20text%20before%20changing%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2799791%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F827443%22%20target%3D%22_blank%22%3E%40egspen2%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20add%20the%20text%20before%20desired%20number%20format%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20404px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F313984iAB97EF9AF077D0F6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

What custom formatting option do I have to pick in order to have the same text appear before different numbers? For example, I'm trying to have cells in consecutive rows show:

 

Customer 1

Customer 2

Customer 3, so on and so forth but just want to be able to add "A1 + 1" and drag it down so that "Customer" automatically populates in front of each number.

1 Reply

@egspen2 

You may add the text before desired number format

image.png