daveb

Posts: n/a

Can I format a cell to round a number by 50 basis points (0.5)?

I am trying to format a number cell so that the decimal value rounds up to
the next .5. Is this possible? I

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
Possible Lookup Table	Karen	Excel Worksheet Functions	5	June 8th 05 09:43 PM
Copy cell format to cell on another worksht and update automatical	kevinm	Excel Worksheet Functions	21	May 19th 05 11:07 AM
Office2000: Conditional format behaves strangely	Arvi Laanemets	Excel Discussion (Misc queries)	1	April 7th 05 08:47 AM
can't format cell - have tried unlocking and unprotecting	griffin	Excel Discussion (Misc queries)	1	April 5th 05 02:11 AM
Formatting a cell as "text" in the number catagory.	Ed	Excel Worksheet Functions	3	December 7th 04 07:12 PM

All times are GMT +1. The time now is 07:31 AM.

About Us

"It's about Microsoft Excel"