Thread: How do you get text to print in subtotal line?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default How do you get text to print in subtotal line?
Usually the title is put in a separate cell to the left of the formula. But
if really want the title in the same cell as the value you can give the cell
this custom format:

"Subtotal " #,##0.00

Tom
Reply With QuoteReply With Quote