A1="Extra Leave Entitlement = "&TEXT(D45,"£#,##0.00")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"mate" wrote in message
...
I have the following:
A1="Extra Leave Entitlement = £"&D45 (where D45 is showing £75.12)
The result is showing:
Extra Leave Entitlement £75.1246883390871
I would like to restrict the result to 2 decimal places as it is a cash
value, how would i do this?
Thanks in advance
--
Jan
|