View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark246 Mark246 is offline
external usenet poster
 
Posts: 19
Default How to force numbers to just 2 digits, not 15 ?

I have a bunch of numbers, created by some pretty tricky calculations.
The end result is ($2.456789) dollars and cents.
It is Displayed as just $2.46, but when I use that in a calculation,
it's 2.456789.
How can I force the info in the cell to be just 2.46 ?
I've tried Copy / Paste special / Values... doesn't work.

Thanks, in advance.

Mark246.