currency - cents format in excel 1

[venkman]

Does someone have a good format string for cents. I'd like it to be of the form
14.5 c

where c is the cents symbol

So far I have it working for number like the one above, but it has trouble with printing out a trailing 0. For instance, instead of:
21.0 c
it shows:
21. c

Notice the decimal point with nothing following it. Is there a standard setting for this that I'm missing?

Thanks,
Venkman

 

[Zathras]

Use a custom format for the cell:

#,##0.0 c

 

[meintsi]

Try using this... 0.0" c"
*Remember.......
If you don't use your head,
your going to have to use your feet.

 

[Zathras]

To get the "cents" symbol, key Alt-0162 (or copy the following

#,##0.0 ¢

 

[xlhelp]

You can also use ALT+0162 in place of c under custom format

 

[venkman]

Thanks Zathras. Your answer was what I was looking for. And thank you all for responding so quickly.
-Venkman