Format of a Cell in Excel with Text.

[taylo40]

Hello,

Can anybody help please ?

I have entered the following formula in to Excel:-

="This will be a saving of " & 12875 * (E25/150)

and excel is displaying the following:-

This will be a saving of 9309.34027777778

Is it possible to format the formula so that it only displays to 2 decimal places ?

Regards,

Jamie

 

[SkipVought]

Hi,
[tt]
="This will be a saving of " & TEXT(12875 * (E25/150),"0.00")
[/tt]

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}