Dates don't format correctly in different computer!

[Wolfy71]

Hi,
I've emailed a workbook through to a new computer (which has the same 2003 Excel edition) and the dates aren't recognized correctly, in my formulas, expressing a '#VALUE!' message, instead!

Any way to get round this? I've tried clearing the contents and reformatting the cells affected, but to no avail...

My guess is it's something to do with add-ins but I don't know the steps I need to take here. This is driving me nuts!

Thanks in advance for your help!

Regards,

Adam

 

[Stormseed]

#VALUE! occurs only when a formula is being used in the cell. What formula do you have in that cell and what are you trying to do ?

 

[AdamL]

I'm guessing that the other computer might have different regional settings where the months/days are swapped around?

As an aside (but possibly related), I noticed one of my computers (XP Pro) for some reason switched to English (US) from English (Australia) settings after a Windows Update.