Trailing zeros

[Gatz]

https://www.microsoft.com/office/co...f2b3ef-0776-4243-a1d9-229c404eedad&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?

 

[PJFry]

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...

 

[JLatham]

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"

 

[Mike H]

Try this

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

Mike

 

[Rick Rothstein]

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"

 

[Gatz]

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