Oct 20 2021 08:43 PM
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?
Oct 20 2021 08:59 PM - edited Oct 20 2021 09:30 PM
@NashGeorge Use "INV-"0 as the custom format.
Edit: Or use "INV-"000000 if the invoice number should, for instance, always be 6 digits.