ExcelBanter - custom number and random text format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - custom number and random text format (https://www.excelbanter.com/excel-discussion-misc-queries/95134-custom-number-random-text-format.html)

CAD Teacher

custom number and random text format

In 2003 SP2, I am looking to take my existing custom format, ###-###-###, and
be able to add occasional random text (A, B, C, etc...), but still keep just
the number if no text is given. Any ideas?

All times are GMT +1. The time now is 01:41 AM.