Excel and Dates

when you enter in excel dates - if the date is in the format of the current culture then when you update the culture , the format will change.

For example if the culture is such:

and you have a s/sh such:

and then you change short format to dd-MMM-yy this will happen:

2 things happened 1) the 3rd cell changed formats 2)the 4th cell changed delimeters

even when you move the original s/sh to a different computer this is what happens

this happens with CSV also


fascinating stuff