Decimal places

[Kreiss]

Is there any way to specify the number of decimal places
to display? I have this formula....

="Total Days = "& (D26+H26+L26)

I can't format the cell to currency b/c of the text.

thanks,
kacy

 

[JulieD]

Hi Kacy

try
="Total Days = " & TEXT(D26+H26+L26,"$#,##0.00")

Regards
JulieD

 

[Peo Sjoblom]

Assuming you are using dollars

="Total Days = "&TEXT(D26+H26+L26,"$#,##0.00")

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Norman Harker]

Hi Kacy!

Try:

="Total Days = "& TEXT((D26+H26+L26),"$0.00")