Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2004
    Location
    Jefferson City, Missouri, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    excel XP strange (2002 (10.6501.6626) SP#)

    Some one in our office has discovered if you enter a5-9 into a cell, it displays arabic characters followed by the -9. The data entry shows a date 6/26/2004. If you click to enter in the cell, the data 6/26/2004 appears. If you press enter with no changes, the arabic characters reappear. I have attached a screen shot because I cannot capture the characters in any other method.

    This is strange. We can do it on three different machines. Each with different levels of service packs but all using Excel XP and Windows 2000. I would like to hear if other can do this.

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

    Re: excel XP strange (2002 (10.6501.6626) SP#)

    This is a known problem. See XL2002: Cells Automatically Format with Hijri Date Format When You Type "a-" Before a Number for an explanation and a way to avoid this behavior.

  3. #3
    New Lounger
    Join Date
    Apr 2004
    Location
    Jefferson City, Missouri, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel XP strange (2002 (10.6501.6626) SP#)

    Thanks for the quick response.

Posting Permissions

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