View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Rounding Numbers

=ROUNDDOWN(A1,2)

--
Kind regards,

Niek Otten

"KHinMN" wrote in message
...
I need to "lop off" a fractional number -- but not round it. Kind of like
truncating only not to an integar -- keeping to 100th decimal place.

1.6595959 would be 1.65

Is that the same as rounding down? I guess I'll try that next -- unless
someone else has another idea?