Stopping zeroes from being dropped after decimal points

[cactusdr]

I've read various "solutions" to my request but it's Greek to me. Simply stated I occasionally have to create worksheets that involve dollars and cents. My question is how can I get Excel to stop dropping the zero if its the last digit to the right of the decimal point? $42.30 becomes $42.3, etc.

I've looked through the preferences/options and can find nothing to rectify this. Any way to do this so that keeping the zero becomes the default for any tables, lists, etc that I create in the future? Thank you in advance.

[shg]

Select the cells(s) and click the button with the $ on the Home tab, Number group.

[MarvinP]

Hi cactusdr and welcome to the forum,

I've searched on "Excel Number Format 2007" and found a link to answer your question. I hope this will extend to other types of formats you may want to do also.

http://www.dummies.com/how-to/conten...xcel-2007.html

[cactusdr]

Select the cells(s) and click the button with the $ on the Home tab, Number group.

Perfect! The only variation I utilized was selecting Number from the dropdown menu. It eliminated the redundancy of the dollar sign in each cell.

I've searched on "Excel Number Format 2007" and found a link to answer your question. I hope this will extend to other types of formats you may want to do also.

http://www.dummies.com/how-to/conten...xcel-2007.html

Great source!! Right up my alley. Thank you for providing the link as it provides, as you say, for multiple formats depending on the need for cells.

*Thanks so much to both for your responses that accurately addressed my problem.

[shg]

Yer welcome.