ExcelBanter - How to display decimal number only?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to display decimal number only? (https://www.excelbanter.com/excel-discussion-misc-queries/193812-how-display-decimal-number-only.html)

Eric

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

Rick Rothstein \(MVP - VB\)[_824_]

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

All times are GMT +1. The time now is 10:29 AM.