Not quite, but as close as I can get

[<1].00c;$#,##0.00

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Montana" wrote in message
...
I need a cell to read 69¢ if the amount is below a dollar, but $1.69 if the
amount exceeds a dollar. I know how to do either in FORMAT CELLS, but how
do
I get Excel to see and format the cell based on this criteria?

Thank you in advance.