erratic decimal points and rounding

[dbann]

Hi all,

First post here! I have a minor issue which causes major headaches... Excel 2010....

Excel looses decimal places when I copy information from cells.


Cell B1: 0.00
Cell B2 2.00

Cell C1: " =B1 &"(" &B2&")"

Cell C1 now reads 0(2) - I want it to give the full decimal places - 0.00(2.00). I have formatted cells B1 and B2 to be 2 decimal places, and set excel to "set precision as displayed"

This is quite an annoying issue when copying multiple data from statistical packages. It means that some are consistent to 2 DP, while others are not and require manual changing. I've had a look online but couldn't find anything for it!

Help very much appreciated,

best wishes

Dave

 

[Andrew Poulsom]

Welcome to MrExcel.

Try:

=TEXT(B1,"0.00")&"("&TEXT(B2,"0.00")&")"

You can't do it without specifying the format in the TEXT function.

 

[VoG]

Try

=TEXT(B1,"0.00") &"(" &TEXT(B2,"0.00")&")"

 

[dbann]

Thank you very much VoG and Andrew Poulsom - you have extremely quickly resolved the problem. Much appreciated!!

David