adding a fixed decimal within another formula
 

using the formula,

=CONCATENATE("Text = ",58.5," + ",F33,)

everything is perfect except the F33 cell is reading with many decimal
points. i have formatted the cell with the correct number of decimal points,
which is 2. i have tried adding in the "=FIXED" formula but i just can't get
it. the cell reads:

Text = 58.5 + 1.62416666666667

all my formatting as a custom cell with currency and decimal places doesn't
seem to apply. i would like the cell to read

Text = $58.50 + $1.62

THANKS!

adding a fixed decimal within another formula
 

="Text = $58.50 + "&DOLLAR(F33)

"h." wrote:

using the formula,

=CONCATENATE("Text = ",58.5," + ",F33,)

everything is perfect except the F33 cell is reading with many decimal
points. i have formatted the cell with the correct number of decimal points,
which is 2. i have tried adding in the "=FIXED" formula but i just can't get
it. the cell reads:

Text = 58.5 + 1.62416666666667

all my formatting as a custom cell with currency and decimal places doesn't
seem to apply. i would like the cell to read

Text = $58.50 + $1.62

THANKS!

adding a fixed decimal within another formula
 

Try: ="Text = "&TEXT(58.5,"$0.00")&" + "&TEXT(F33,"$0.00")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"h." wrote:
using the formula,

=CONCATENATE("Text = ",58.5," + ",F33,)

everything is perfect except the F33 cell is reading with many decimal
points. i have formatted the cell with the correct number of decimal points,
which is 2. i have tried adding in the "=FIXED" formula but i just can't get
it. the cell reads:

Text = 58.5 + 1.62416666666667

all my formatting as a custom cell with currency and decimal places doesn't
seem to apply. i would like the cell to read

Text = $58.50 + $1.62

THANKS!

adding a fixed decimal within another formula
 

You could use TRUNC, but remember that it will lose the rest of the
value in your result. Also, the & is the concatenate operator.

="Text $58.50 + $"&TRUNC(D6,2)

On May 12, 11:03 am, h. wrote:
using the formula,

=CONCATENATE("Text = ",58.5," + ",F33,)

everything is perfect except the F33 cell is reading with many decimal
points. i have formatted the cell with the correct number of decimal points,
which is 2. i have tried adding in the "=FIXED" formula but i just can't get
it. the cell reads:

Text = 58.5 + 1.62416666666667

all my formatting as a custom cell with currency and decimal places doesn't
seem to apply. i would like the cell to read

Text = $58.50 + $1.62

THANKS!

adding a fixed decimal within another formula
 

Here is one more way for you to consider...

=TEXT(F33,"""Text = $58.50 + ""$0.00")

Rick


"h." wrote in message
...
using the formula,

=CONCATENATE("Text = ",58.5," + ",F33,)

everything is perfect except the F33 cell is reading with many decimal
points. i have formatted the cell with the correct number of decimal
points,
which is 2. i have tried adding in the "=FIXED" formula but i just can't
get
it. the cell reads:

Text = 58.5 + 1.62416666666667

all my formatting as a custom cell with currency and decimal places
doesn't
seem to apply. i would like the cell to read

Text = $58.50 + $1.62

THANKS!