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.

Problem with Rounding (2007)
 

You need to use the text function. Try

=Text(ROUND(AP10,3),"0.000")&"""&" x "&Text(ROUND(AR8,3),"0.000")&"""
--
David W Ackerman


"tvh" wrote:

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.

Problem with Rounding (2007)
 

Thanks, David

I had to slightly modify the formula for it to work:
=TEXT(ROUND(AP10,3),"0.000")&""""&TEXT(ROUND(AR8,3 ),"0.000")&""""

I added two extra " marks.

Thanks!!!

"DAckerman Hyannis,MA" wrote:

You need to use the text function. Try

=Text(ROUND(AP10,3),"0.000")&"""&" x "&Text(ROUND(AR8,3),"0.000")&"""
--
David W Ackerman


"tvh" wrote:

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.

Problem with Rounding (2007)
 

"tvh" wrote:
This is the formula I have in cell H61:
=ROUND(AP10,3)&""""&" x "&ROUND(AR8,3)&""""
[....]
I would like the result to show: 6.600" x 0.280"

The following should suffice:

=TEXT(AP10,"0.000") & """ x " & TEXT(AR8,"0.000") & """"


----- original message -----

"tvh" wrote:
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.

Problem with Rounding (2007)
 

On Fri, 19 Mar 2010 08:17:01 -0700, tvh wrote:

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.


=TEXT(AP10,"0.000\""") & " x " & TEXT(AR8,"0.000\""")

--ron