| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display decimal number only?
Does anyone have any suggestions on how to display decimal number only? For
example, 10.28 in cell A1, and I would like to show 0.28 in cell B1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display decimal number only?
Use this formula in B1...
=MOD(A1,1) Rick "Eric" wrote in message ... Does anyone have any suggestions on how to display decimal number only? For example, 10.28 in cell A1, and I would like to show 0.28 in cell B1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting: display blank when "O", 2 decimal when a number is d | New Users to Excel | |||
| Display a number as a decimal | Excel Discussion (Misc queries) | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| display a number that is decimal degrees in Deg:min:sec format | Excel Discussion (Misc queries) | |||
| Numbers display as decimal, i.e. enter 123 display 1.23 | Setting up and Configuration of Excel | |||
Linear Mode
