Thread
:
Format cell to the nearest 100
View Single Post
#
1
December 15th, 2008, 09:57 PM posted to microsoft.public.excel.misc
Gandor
external usenet poster
Posts: 14
Format cell to the nearest 100
Is there a format for rounding a cell to the nearest 100 so that 501.35
rounds to 500. I was using #,##0 to just round to the dollar, but I want to
got to the nearest 100.
Any thoughts?
Gandor
View Public Profile
View message headers
Find all posts by Gandor
Find all threads started by Gandor