| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert a decimal into a fixed number? | Excel Discussion (Misc queries) | |||
| Fixed Decimal | Excel Worksheet Functions | |||
| Fixed Decimal Question | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| Fixed decimal place | Setting up and Configuration of Excel | |||
Threaded Mode
