custom number format code using letters and numbers
Number format applies to numbers.
You could type your entry in one column and use a formula in another.
=left(a1,3)&"-"&mid(a1,4,255)
(255 is a big number large enough to retrieve that last portion)
Foo Foo Daddy wrote:
How can I format my cell to display letters, a dash, then #s? For example:
ABC-12345678, or 2DE-12347562, or FG3-46518673?
--
Dave Peterson
|