Many thanks to all of you for helping me out, my problem is solved once
again.
Appreciate the assistance

BOB

"LabrGuy Bob R" wrote in message
...
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