Posted to microsoft.public.excel.misc

jpowers

Posts: n/a

Is there a way to round currency?

Is there a way to round currency with cents=.50 to .99 and cents <=.49 to .49?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Incorrect Currency Displayed	Maxy	Excel Discussion (Misc queries)	4	November 9th 05 03:20 PM
Round whole numbers up and down	JoeBed	Excel Discussion (Misc queries)	4	July 5th 05 05:21 PM
Can you format a whole column of numbers to round?	dawn	Excel Worksheet Functions	4	June 9th 05 07:31 PM
Currency Style button	Anita	Excel Discussion (Misc queries)	3	April 18th 05 12:48 AM
I am trying to round currency to the closest .50, can anyone tell.	sueshe	Excel Discussion (Misc queries)	4	January 27th 05 08:49 PM

All times are GMT +1. The time now is 08:23 AM.

About Us

"It's about Microsoft Excel"