Posted to microsoft.public.excel.misc

tvh

external usenet poster

Posts: 11

Problem with Rounding (2007)

For some reason I'm not able to round to the third decimal place. This is
the formula I have in cell H61: =ROUND(AP10,3)&""""&" x "&ROUND(AR8,3)&""""

Where, for example:
AP10 = 6.600 (formatted to 3 decimal places, with no " marks)
AR8 = 0.280 (same formatting as above)

I would like the result to show: 6.600" x 0.280"

But I'm getting: 6.6" x 0.28"

Formatting the H61 cell doesn't work either.

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
Rounding Problem	Ross	Excel Discussion (Misc queries)	5	April 3rd 09 01:53 AM
Rounding Problem	kleivakat	Excel Discussion (Misc queries)	3	December 5th 07 10:34 PM
Rounding Problem	Alfred Kaufmann	New Users to Excel	8	September 3rd 07 11:22 PM
Rounding Problem	PWS	Excel Worksheet Functions	5	March 9th 07 05:21 PM
Rounding Problem	Mike	Excel Discussion (Misc queries)	8	September 9th 06 03:59 PM

All times are GMT +1. The time now is 02:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us