Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    All decimal formats display "N" instead of decimal (97 SR-2)

    Greetings!

    One of my users suddenly experienced a very strange phenomenon: When he started his computer this morning and opened Excel, all of his decimal formats displayed the character "N" instead of a decimal. This is the case for ALL Excel workbooks he opens.

    We checked the font for corruption. That was not the problem. We checked the cell formatting, but Number, Currency, and Accounting all display "N" instead of a decimal point. The only way we can get a decimal point to display is by using the Custom format (something like ###.#0).

    I've searched MSKB with no luck. This one has me baffled! Any thoughts? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    RESOLVED: All decimal formats display "N" instead

    Get ready for a big laugh <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>

    Windows Control Panel: Regional Settings. The Decimal Symbol mysteriously changed itself to "N" instead of "."

    Things like this make me want to...
    <img src=/S/smash.gif border=0 alt=smash width=30 height=26>
    <img src=/S/lilputer.gif border=0 alt=lilputer 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
  •