https://www.microsoft.com/office/com...dad&sloc=en-us

This previous thread kinda touched on a solution to the problem of showing
trailing zeros, but the values I want to show are further used in other
succeeding formulae; is converting to TEXT (as was explained) the way to show
"significant digits"? or am I not understanding the use of TEXT

Here's what I'd like to do...
divide D31 by E31, take that number to 2 significant digits following the
decimal point, then add " : 1" as a text string without dropping the final
zero(s) if there happen to be any in the division.

In one case, D31 = 16, and E31 = 3

Here's what I have so far.....

=ROUND(D31/E31,2)&" : 1"

I get the results I'm looking for.... 5.33 : 1

However, when using (different cell values) D33 = 16 and E33 = 5

and =ROUND(D33/E33,2)&" : 1"

I get...... 3.2 : 1

How can I get the zero behind 3.2 and any other results to 2 places past the
decimal?

Text is the best way to show the significant digits. Once you add the :1 to
your answer, it's not a number any more anyway.

=TEXT(ROUND(A1/B1,2),"0.00")&" : 1"
is your best bet.

p.s. I tried review the other post, but I kept getting an error. Hopefully
this answer wasn't the same thing you got before...

--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Gatz" wrote:


https://www.microsoft.com/office/com...dad&sloc=en-us

This previous thread kinda touched on a solution to the problem of showing
trailing zeros, but the values I want to show are further used in other
succeeding formulae; is converting to TEXT (as was explained) the way to show
"significant digits"? or am I not understanding the use of TEXT

Here's what I'd like to do...
divide D31 by E31, take that number to 2 significant digits following the
decimal point, then add " : 1" as a text string without dropping the final
zero(s) if there happen to be any in the division.

In one case, D31 = 16, and E31 = 3

Here's what I have so far.....

=ROUND(D31/E31,2)&" : 1"

I get the results I'm looking for.... 5.33 : 1

However, when using (different cell values) D33 = 16 and E33 = 5

and =ROUND(D33/E33,2)&" : 1"

I get...... 3.2 : 1

How can I get the zero behind 3.2 and any other results to 2 places past the
decimal?

I believe because you're eventually converting the whole result to a text
string that you'll need to use Text() to accomplish what you need. Try
something like this:

=TEXT(ROUND(D33/E33,2),"#.00") &" : 1"
or this, if you want to show a 0 on left side of the decimal if the result
is only a decimal value:
=TEXT(ROUND(D33/E33,2),"0.00") &" : 1"


"Gatz" wrote:


https://www.microsoft.com/office/com...dad&sloc=en-us

This previous thread kinda touched on a solution to the problem of showing
trailing zeros, but the values I want to show are further used in other
succeeding formulae; is converting to TEXT (as was explained) the way to show
"significant digits"? or am I not understanding the use of TEXT

Here's what I'd like to do...
divide D31 by E31, take that number to 2 significant digits following the
decimal point, then add " : 1" as a text string without dropping the final
zero(s) if there happen to be any in the division.

In one case, D31 = 16, and E31 = 3

Here's what I have so far.....

=ROUND(D31/E31,2)&" : 1"

I get the results I'm looking for.... 5.33 : 1

However, when using (different cell values) D33 = 16 and E33 = 5

and =ROUND(D33/E33,2)&" : 1"

I get...... 3.2 : 1

How can I get the zero behind 3.2 and any other results to 2 places past the
decimal?

Try this

=TEXT(ROUND(D31/E31,2),"0.00")&" : 1"

Mike

"Gatz" wrote:


https://www.microsoft.com/office/com...dad&sloc=en-us

This previous thread kinda touched on a solution to the problem of showing
trailing zeros, but the values I want to show are further used in other
succeeding formulae; is converting to TEXT (as was explained) the way to show
"significant digits"? or am I not understanding the use of TEXT

Here's what I'd like to do...
divide D31 by E31, take that number to 2 significant digits following the
decimal point, then add " : 1" as a text string without dropping the final
zero(s) if there happen to be any in the division.

In one case, D31 = 16, and E31 = 3

Here's what I have so far.....

=ROUND(D31/E31,2)&" : 1"

I get the results I'm looking for.... 5.33 : 1

However, when using (different cell values) D33 = 16 and E33 = 5

and =ROUND(D33/E33,2)&" : 1"

I get...... 3.2 : 1

How can I get the zero behind 3.2 and any other results to 2 places past the
decimal?

If you use the TEXT function as others have advised, you really do not need
the ROUND function call they have shown as the TEXT function will do that
rounding automatically...

=TEXT(D31/E31,"0.00")&" : 1"

--
Rick (MVP - Excel)


"Gatz" wrote in message
...

https://www.microsoft.com/office/com...dad&sloc=en-us

This previous thread kinda touched on a solution to the problem of showing
trailing zeros, but the values I want to show are further used in other
succeeding formulae; is converting to TEXT (as was explained) the way to
show
"significant digits"? or am I not understanding the use of TEXT

Here's what I'd like to do...
divide D31 by E31, take that number to 2 significant digits following the
decimal point, then add " : 1" as a text string without dropping the final
zero(s) if there happen to be any in the division.

In one case, D31 = 16, and E31 = 3

Here's what I have so far.....

=ROUND(D31/E31,2)&" : 1"

I get the results I'm looking for.... 5.33 : 1

However, when using (different cell values) D33 = 16 and E33 = 5

and =ROUND(D33/E33,2)&" : 1"

I get...... 3.2 : 1

How can I get the zero behind 3.2 and any other results to 2 places past
the
decimal?

Thanx to all that responded..I will try the suggestions.

Also, I don't know if my clicking on the YES button did anything...seems
like sometimes I'm able to read all responses to (any) question , then
sometimes the window to the right of the Discussion topics just goes blank.

Had to try several times to get all the responses to show upon clicking.

Gatz

"Mike H" wrote:

Try this

=TEXT(ROUND(D31/E31,2),"0.00")&" : 1"

Mike

"Gatz" wrote:


https://www.microsoft.com/office/com...dad&sloc=en-us

This previous thread kinda touched on a solution to the problem of showing
trailing zeros, but the values I want to show are further used in other
succeeding formulae; is converting to TEXT (as was explained) the way to show
"significant digits"? or am I not understanding the use of TEXT

Here's what I'd like to do...
divide D31 by E31, take that number to 2 significant digits following the
decimal point, then add " : 1" as a text string without dropping the final
zero(s) if there happen to be any in the division.

In one case, D31 = 16, and E31 = 3

Here's what I have so far.....

=ROUND(D31/E31,2)&" : 1"

I get the results I'm looking for.... 5.33 : 1

However, when using (different cell values) D33 = 16 and E33 = 5

and =ROUND(D33/E33,2)&" : 1"

I get...... 3.2 : 1

How can I get the zero behind 3.2 and any other results to 2 places past the
decimal?