View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
h. h. is offline
external usenet poster
 
Posts: 4
Default 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!