Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need a sentence saying: 2 half-time leads in 4 games (66,67%) has resulted
in 1 win. I've got these cells: (A1=2) (A2=4) (A3=66,67%) and I tried this: =concatenate("";a1;" half-time leads in ";a2;" games (";a3;") has resulted in 1 win."). But the result is: 2 half-time leads in 4 games (0,66666666666666667) etc Then I tried this: =concatenate("";a1;" half-time leads in ";a2;" games (";a3*100;"%) has resulted in 1 win.") The result: 2 half-time leads in 4 games (66,666666666666667%) etc How can I return only 2 digits, so the result is 66,67% ?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you change single digits to recognized double digits? | Excel Worksheet Functions | |||
VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
number 12 digits to 15 digits | Excel Discussion (Misc queries) | |||
How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
Concatenate function - keeping "displayed" extra digits | Excel Discussion (Misc queries) |