A1-1 changes format to Aribic date format
 

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.

A1-1 changes format to Aribic date format
 

Hi,

Is there an = sign in front of the A1-1?

Shane Devenshire

"Carla" wrote:

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.

A1-1 changes format to Aribic date format
 

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\E xcel\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.

--
Biff
Microsoft Excel MVP


"Carla" wrote:

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.

A1-1 changes format to Aribic date format
 

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.
"Shane Devenshire" wrote:

Hi,

Is there an = sign in front of the A1-1?

Shane Devenshire

"Carla" wrote:

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.

A1-1 changes format to Aribic date format
 

Here's the official MS support link:

http://support.microsoft.com/default.aspx/kb/812385

--
Biff
Microsoft Excel MVP


"T. Valko" wrote:

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\E xcel\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.

--
Biff
Microsoft Excel MVP


"Carla" wrote:

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.

A1-1 changes format to Aribic date format
 

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

"T. Valko" wrote:

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\E xcel\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.

--
Biff
Microsoft Excel MVP


"Carla" wrote:

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.

A1-1 changes format to Aribic date format
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Carla" wrote:

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

"T. Valko" wrote:

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\E xcel\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.

--
Biff
Microsoft Excel MVP


"Carla" wrote:

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.

A1-1 changes format to Aribic date format
 

http://support.microsoft.com/?id=812385
Shows a registry tweak to turn it off.

The key in the registry will changed depending on the version of excel that
you're using.


Carla wrote:

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.

--

Dave Peterson

A1-1 changes format to Aribic date format
 

And the question is?

Regards,
Fred.

"Carla" wrote in message
...
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.