Excel Custom Format

Copper Contributor

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.