ExcelBanter - &Text &Link 2 Dec places

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - &Text &Link 2 Dec places (https://www.excelbanter.com/excel-worksheet-functions/16415-text-link-2-dec-places.html)

mate

&Text &Link 2 Dec places

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

Bob Phillips

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

mate

Thank you very much, worked perfectly!

Jan

"Bob Phillips" wrote in message
...
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

All times are GMT +1. The time now is 08:37 PM.