Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello, I have Excel 2003 and Windows XP Pro.
I use this formula and it works exactly like I want it to except:: =IF(AC8<AC7,"YES Credit for " & "$" & AC8,"NO Max Credit for " & "$" & AC7) AC8 and AC7 are both currency values and I get formatting of it like this $133 $133.1 $133.10 I would always like to return a full currency value like the $133.10 but can't figure it out. The two cells are both formatted in currency and display two decimal places Anyone have any ideas that it will format each time?? Thanks Bob R |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert text to dollar | Excel Discussion (Misc queries) | |||
How do I assign dollar value to text | New Users to Excel | |||
formatting text on chart for specific values | Charts and Charting in Excel | |||
Force values-only when pasting text to keep formatting | Excel Discussion (Misc queries) | |||
Dollar text | Excel Discussion (Misc queries) |