Arabic Dates - special feature!

[katem]

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

 

[NickHK]

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