Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding Problem | Excel Discussion (Misc queries) | |||
Rounding Problem | Excel Discussion (Misc queries) | |||
Rounding Problem | New Users to Excel | |||
Rounding Problem | Excel Worksheet Functions | |||
Rounding Problem | Excel Discussion (Misc queries) |