| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show Two Decimal Places After Concatenation
I extend my thanks to everyone who got involved!
"John Bundy" wrote: Here you go =TEXT(A1,"£0.00") -- -John Please rate when your question is answered to help us and others know what is helpful. "ryguy7272" wrote: The value below is generated by a function. I used the "&" symbol to concatenate the "£" with the value. Sometimes I use a "$" and sometimes I use a "‚¬". Now, I'm trying to show just two decimal places. £9506944.44444444 Can someone please help out? TIA!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Max decimal places | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| decimal places | Excel Discussion (Misc queries) | |||
| decimal places | Excel Discussion (Misc queries) | |||
Hybrid Mode
