Thread: ROUNDING ISSUE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
F.G. F.G. is offline
external usenet poster
 
Posts: 28
Default ROUNDING ISSUE

Hi all,

How do I ask Excel to stop "rounding"?

I know Round up and down functions however I want excel to stop "rounding" and do not take into account the decimals.

Example:
whether the result is $1,375.35 or $1,375.85 I want excel ignore the decimals and to show $1,375 and not "round" to $1,375 or $1,376.

Thank you for all you help.

Best,
Frank Gashi
The City University of New York