View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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