Excel amount field formatting error

  • Thread starter Thread starter slmm
  • Start date Start date
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
 
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
 
Back
Top