How do you get text to print in subtotal line?

G

Ginny

I am trying to use subtotal on my spreadsheet and I cannot get the text to
show up on the subtotal line.
 
T

TomPl

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Need Text columns to pull into subtotal lines 7
Sumproduct Ignore Text 2
subtotal, match? 10
Subtotal 3
How do I get the "subtotal" columns in XL in Office '07? 2
Multiple Subtotal Placement 2
Subtotal of values in cells containing formula 1

Top