View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kell~0 kell~0 is offline
external usenet poster
 
Posts: 1
Default How do I show only the whole number w/o eliminating four decimals?

I need to show only the whole number, not the number resulting by removing
the decimals. We do not want to force all of these cells.

So, if the number is $104,978.6849 it needs to show $104,978, not $104,979

How do I do this?