| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display zero in a number to 1dp e.g. 14.0 without stripping the zero
I have the following formula in a cell:
="" & IF(B3="","",IF(ISNUMBER(B3),ROUND(100*B3,1),B3)), it is reading the value 13.96% (cell B3). The displayed value is being rounded to one decimal place, i.e. 14.0, however, the actual value being displayed is 14, the '.0' is being stripped. How can I force it to display the '.0'? I have tried using the TEXT function but wherever I put it in the above formula it give me an error. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display zero in a number to 1dp e.g. 14.0 without stripping the zero
=IF(B3="","",IF(ISNUMBER(B3),TEXT(ROUND(100*B3,1), "0.0"),B3))
wrote: I have the following formula in a cell: ="" & IF(B3="","",IF(ISNUMBER(B3),ROUND(100*B3,1),B3)), it is reading the value 13.96% (cell B3). The displayed value is being rounded to one decimal place, i.e. 14.0, however, the actual value being displayed is 14, the '.0' is being stripped. How can I force it to display the '.0'? I have tried using the TEXT function but wherever I put it in the above formula it give me an error. Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display zero in a number to 1dp e.g. 14.0 without stripping the zero
I don't understand what the first part is
="" it doesn't do anything, if you want text use the text function =IF(B3="","",IF(ISNUMBER(B3),TEXT(ROUND(100*B3,1), "0.0"),B3)) -- Regards, Peo Sjoblom wrote in message ups.com... I have the following formula in a cell: ="" & IF(B3="","",IF(ISNUMBER(B3),ROUND(100*B3,1),B3)), it is reading the value 13.96% (cell B3). The displayed value is being rounded to one decimal place, i.e. 14.0, however, the actual value being displayed is 14, the '.0' is being stripped. How can I force it to display the '.0'? I have tried using the TEXT function but wherever I put it in the above formula it give me an error. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stripping The First Four Characters from a value | Excel Discussion (Misc queries) | |||
| Stripping text before a number (alpha or numeric) | Excel Worksheet Functions | |||
| display total above certain number and display | Excel Discussion (Misc queries) | |||
| Stripping and Conversion. | New Users to Excel | |||
| Stripping mixed number and text | Excel Worksheet Functions | |||
Linear Mode
