Excel amount field formatting error

S

slmm

Excel 2000 version 9.0.6926 sp-3. My amount is 18.00. I select
format-number-currency and my amount becomes $1800.00. Always adding 2
zeroes! It formats correctly if I enter just 18. If my amount is 18.25 it
formats it as $1825.00. I've tried several different formats with no
success. My computer is an hp pavilion xt926. Can someone please help me?!?!
Thank you. Lynn
 
A

Anne Troy

Hi, Lynn. Thanks for providing all the info---most people don't. Go to
Tools-->Options, and click the Edit tab. Untick "Fixed Decimal" thingee. :)
*******************
~Anne Troy

www.OfficeArticles.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Number 2
Excel 2000 autosum not adding correctly 3
Date formats in Excel 2003 under Vista 5
Interactive Woksheet ... How would you do this? 2
SAP to Excel 2007 download format error 0
Decimal point will not hold 2 places in Excel 2003 3
Excel 2003 not recognizing whole dollar amounts, formats amt as ce 1
data to summary sheet for a dummy 0

Top