poppiekat wrote:
One way:

[quoted text clipped - 4 lines]
How do I get the $ sign and the .00 cents to appear in column "C"
when I type it?

Could you please show me the exact formula I need to enter for doing this?
Please ignore my ignorance.....I see now that you said "format" and I was so
frustrated after a long day of dealing with things that I could only read the
word "formula".

I formated the cells with currency $ and two digits .00 and everything is
working just fine.
Your're the greatest !!!

--
Message posted via http://www.officekb.com