Excel 2000 Formatting Decimal Problem

[Ralph Fabiano]

I am trying to concenate/combine the value of two cells
into one; to prepare them for importing in to Simply
Accounting.

Here an example:

Cell A1: 4100
Cell A2: 15.06

The 15.06 is acutally an imported number from our POS
System (pulled via a formular in the spreasheet) with the
real value of 15.060000006, however it is only displayed
with two decimals.

When I concenate/combine the values of the two cells into
one cell I would like to get this as a result:
(4100,15.06) However, due to the value of cell A2, I get
this result: (4100,15.060000006).

How can I go about that the value of cell A2 stays with
two decimals instead of displaying all the decimals?

I know, I can do the copy/paste value only manually. But
I am looking for a formular where I can set the consenate
result to display only upto two decimals.

Thanks - Any help would be appreciated tremendously ....

Ralph Fabiano
(e-mail address removed)

 

[Jeff Foster, MCSA]

Run a formula on cell A2 first to round it off to 2 decimal places. The
formula name is "round"