Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Autoformat (XL 2003)

    We have recently upgraded to XL03 from XL97, and it has one "helpful" feature that I would like to turn off. When I use a financial calculation (say, NPV) it 'magically' formats the result in the currency format, with a dollar sign and two decimal places. Unfortunately, most of the calculations are in thousands of dollars (sometimes millions), and I prefer not to show decimals - so I usually use "Comma[0]" format. Even if I have set the format for the particular cell as Comma[0], if I edit the formula Excel insists on re-setting the format.

    Is there a way to turn off this behaviour? The MS knowledgebase has successfully hidden the answer from me, and I didn't find it in a search here - but maybe that just betrays my poor searching abilities (or patience...)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Autoformat (XL 2003)

    No, I don't think you can turn this off.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Autoformat (XL 2003)

    Thanks, Hans. Not the answer I wanted - but it was the answer I expected <img src=/S/sigh.gif border=0 alt=sigh width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •