Arabic Dates - special feature!
 

Hi,

Just wondering if anyone can help me - we're trying to get some data
out of modelling software & into Excel, for further manipulation. To
do this, you 'copy' the data in the modelling software & then paste it
as a sheet into excel. Unfortunately, some of the nodes are labelled
as 'A1/1' and 'A2/1' and when you paste this in, it magically changes
to an arabic date (type A1/1 into a cell & you'll see what I mean).
Does anyone know how to stop this happening?

Cheers,
Kate

Arabic Dates - special feature!
 

According to:
http://support.microsoft.com/kb/884663/en-me
this is intentional, although in your case not exactly helpful.

Can you arrange for the output to be changed to some other character/symbol
that you can replace after you have it in Excel ?
Or add a ' to beginning of those value, to keep the entry as text.
Or write some routine that gets the month and day from the Hijri and returns
the original string.

NickHK

"katem" wrote in message
oups.com...
Hi,

Just wondering if anyone can help me - we're trying to get some data
out of modelling software & into Excel, for further manipulation. To
do this, you 'copy' the data in the modelling software & then paste it
as a sheet into excel. Unfortunately, some of the nodes are labelled
as 'A1/1' and 'A2/1' and when you paste this in, it magically changes
to an arabic date (type A1/1 into a cell & you'll see what I mean).
Does anyone know how to stop this happening?

Cheers,
Kate