| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
&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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Aligning data with varying decimal places | Excel Discussion (Misc queries) | |||
| Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
| add 2 decimal places | Excel Discussion (Misc queries) | |||
| ROUND DATA TO 2 DECIMAL PLACES | New Users to Excel | |||
| Number Format Issues-Decimal Places | Excel Worksheet Functions | |||
Linear Mode
