Excel 2000 - Decimal Problem

  • Thread starter Thread starter Ralph Fabiano
  • Start date Start date
R

Ralph Fabiano

I am trying to concatenate/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 actually an imported number from our POS
System (pulled via a formula in the spreadsheet) with the
real value of 15.060000006, however it is only displayed
with two decimals.

When I concatenate /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 formula where I can set the
concatenate result to display only up to two decimals.

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

Ralph Fabiano
(e-mail address removed)
 
can also use (for flexibility)
=concatenate(trunc(A1,3),trunc(a2,3))
This will concatenate the valuse of a1 and a2 ...
truncated to desired decimal places each (3 in this case).
 
Back
Top