Thread: Format custom number: C-0000-L
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Format custom number: C-0000-L
Assuming the number is in cell A1 and the letter is in cell A2 then use this
formula:

="C-"&A1&"-"&A2

Not custom formatting.

Tom
Reply With QuoteReply With Quote