A1-1 changes format to Aribic date format

C

Carla

I have Office XP it I type A1-1 in a cell it changes the format to something
like Aribic and then the number 1. If you look fx line it show the date of
12/28/2008.
 
T

T. Valko

You can fix this with a registry tweak. If you are not familiar with changing
registry keys I would avoid doing this. If you make a mistake you can do
great damage to your computer!

In Excel 2002 you enter a string in a cell like: A1-1

Excel automatically formats this entry as an Arabic date.

This registry edit fixes this so it won't format as an Arabic date.

1. Quit all Microsoft Windows programs, including Microsoft Excel 2002.
2. Click Start, and then click Run.
3. In the Open box, type regedit, and then click OK.
4. Locate and then select the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options
5. On the Edit menu, click New, and then click DWORD Value.
6. Type xl9_hijri, and then press ENTER.
7. On the Edit menu, click Modify.
8. Type 1, and then click OK.
9. On the Registry menu, click Exit.

Credit to Ron Rosenfeld for finding this.
 
C

Carla

No just A1-1 the last number can be any number. If you change the 1 to a 2
it changes the date that is displayed. I also have Office 2007 and this does
not happen in that version.
 
C

Carla

Thank you that worked like a charm. I have a couple of computers with the
same thing so I exported the key and will run on the other machines.
Thanks again
Carla
 

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


Top