LinkBack URL
About LinkBacks
Hello friends,
I hope you all are doing well. I have these two numbers in two different cells (there are confidence intervals).
0.6316 0.8160
I need them to be in in one cell but with only two decimal places:
0.63-0.82
Thank you,
Marvin
Hello friends,
I hope you all are doing well. I have these two numbers in two different cells (there are confidence intervals).
0.6316 0.8160
I need them to be in in one cell but with only two decimal places:
0.63-0.82
Thank you,
Marvin
=Text(H5,"00,00")&" - "&Text(I5,"00,00")
in which H5 = 0.6316
in which I5 = 0.8160
Last edited by oeldere; 06-02-2015 at 05:23 PM. Reason: in which
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi,
=ROUND(A1,2)&"-"&ROUND(B1,2)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Try this
=TEXT(A1,"#0.00")&"-"&TEXT(B1,"#0.00")
Row\Col 0.63-0.82
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
WOw- guys the three formulas work perfectly but at the end I used Alkey's formula. Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks