How to display decimal number only?
in [General]
|
From: Eric on 6 Jul 2008 05:28 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
From: Rick Rothstein (MVP - VB) on 6 Jul 2008 05:38 Use this formula in B1... =MOD(A1,1) Rick "Eric" <Eric(a)discussions.microsoft.com> wrote in message news:82BEF008-59C1-4939-9FAC-476F2297075E(a)microsoft.com... > 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
|
Pages: 1 Prev: Print Worksheet Poster Size Next: rearranging formula suggestion |