View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default custom number format code using letters and numbers

Hi,
Let's say in column A you have your letters and in column B your numbers
then in column C enter

=A1&"-"&B1

copy formula down

if this helps please click yes, thanks

"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?