| 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 |
| 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 | |||
Threaded Mode
