From: Iriemon on 24 Feb 2010 10:09 I have the following formula in one of my cells: =IF(C5<>0,C6 &" Supplied by Marketing - Calculated value is " &C4,C4&" Calculated value") The values in C4, C5, C6 are all in dollar format but the output doesn't show in dollar format. See below: 7500 Supplied by Marketing - Calculated value is 8800 . Any way to get the format like this: \$7,500.00 Supplied by Marketing - Calculated value is \$8,800.00 From: Eduardo on 24 Feb 2010 10:17 Hi, =IF(C5<>0,"\$"&C6&" Supplied by Marketing - Calculated value is "&"\$"&C4,C4&" ") "Iriemon" wrote: > I have the following formula in one of my cells: > > =IF(C5<>0,C6 &" Supplied by Marketing - Calculated value is " &C4,C4&" > Calculated value") > > The values in C4, C5, C6 are all in dollar format but the output doesn't > show in dollar format. See below: > > 7500 Supplied by Marketing - Calculated value is 8800 . > > Any way to get the format like this: > > \$7,500.00 Supplied by Marketing - Calculated value is \$8,800.00 > > From: Iriemon on 24 Feb 2010 10:23 Thanks Eduardo! works fine! "Eduardo" wrote: > Hi, > > =IF(C5<>0,"\$"&C6&" Supplied by Marketing - Calculated value is "&"\$"&C4,C4&" > ") > > "Iriemon" wrote: > > > I have the following formula in one of my cells: > > > > =IF(C5<>0,C6 &" Supplied by Marketing - Calculated value is " &C4,C4&" > > Calculated value") > > > > The values in C4, C5, C6 are all in dollar format but the output doesn't > > show in dollar format. See below: > > > > 7500 Supplied by Marketing - Calculated value is 8800 . > > > > Any way to get the format like this: > > > > \$7,500.00 Supplied by Marketing - Calculated value is \$8,800.00 > > > >  |