View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_824_] Rick Rothstein \(MVP - VB\)[_824_] is offline
external usenet poster
 
Posts: 1
Default 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