View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LabrGuy Bob R LabrGuy Bob R is offline
external usenet poster
 
Posts: 23
Default Formatting dollar values in text

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