completely remove decimals - not just hiding them

[notshot]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I need to have the decimals completely removed from my sheet (not just reducing decimal places from the tool box).
Reason - I want to merge two cells so the number in right cell comes in ( ) behin the number in left cell. If I just merge or copy it in any way all decimals "follow" to the new cell even if none are showing from the original cell:
example/task:
Cell A1: 22222
Cell A2: 33.666
should be transformed to
Cell A3 and display 22222(34).

Reason I need it it to easily export big data sheets to more layout friendly tables in word.
Hope someone can help.

 

[John McGhie]

You need to round off both values to get rid of the decimal fractions, then
convert each to text and concatenate with your parentheses.

Use the following formula in Cell A3 and fill down...

=TEXT(ROUND(A1,0),0)&"("&TEXT(ROUND(B1,0),0)&")"

Cheers

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I need to have
the decimals completely removed from my sheet (not just reducing decimal
places from the tool box).
Reason - I want to merge two cells so the number in right cell comes in ( )
behin the number in left cell. If I just merge or copy it in any way all
decimals "follow" to the new cell even if none are showing from the original
cell:
example/task:
Cell A1: 22222
Cell A2: 33.666
should be transformed to
Cell A3 and display 22222(34).

Reason I need it it to easily export big data sheets to more layout friendly
tables in word.
Hope someone can help.

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

 

[CyberTaz]

One approach: In cell A3 enter the formula;

=A1&"("&ROUND(A2,0)&")"

Then copy A3, leave the cell selected & use Edit> Paste Special - Values to
replace the formula with the literal result.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[notshot]

Thank you very much - excellent.