Excel Custom Format

%3CLINGO-SUB%20id%3D%22lingo-sub-2867865%22%20slang%3D%22en-US%22%3EExcel%20Custom%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2867865%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20any%20one%20help%20me%20to%20custom%20format%20the%20following%20to%20come%20automatic%20in%20a%20cell.%20I%20wanted%20to%20format%20my%20excel%20cell%20like%20if%20I%20enter%20an%20invoice%20number%2C%20%22INV-%22%20should%20come%20automatically.%20I%20tried%20to%20format%20INV-0000%2C%20excel%20is%20not%20accepting%20that%20format.%20But%20if%20I%20try%20for%20purchase%20order%20%22PO-%22%20to%20come%20automatically%2C%20it%20works%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2867865%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2867892%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Custom%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2867892%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1191561%22%20target%3D%22_blank%22%3E%40NashGeorge%3C%2FA%3E%26nbsp%3BUse%20%3CSTRONG%3E%22INV-%220%20%3C%2FSTRONG%3Eas%20the%26nbsp%3Bcustom%20format.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

Can any one help me to custom format the following to come automatic in a cell. I wanted to format my excel cell like if I enter an invoice number, "INV-" should come automatically. I tried to format INV-0000, excel is not accepting that format. But if I try for purchase order "PO-" to come automatically, it works? 

1 Reply

@NashGeorge Use "INV-"0 as the custom format.

 

Edit: Or use  "INV-"000000 if the invoice number should, for instance, always be 6 digits.