L
lordslayer
Helo!
I made a query view on sql server. Among other fields there was also a
datetime field. Then i imported this data to Excel using a Pivot table
(get external data). I wanted to manipulate dates using "Group and
Outline" however when i tried, dates were all wrong and grouping was
also wrong. The date format should be like "04.05.2003" but instead od
dots "." between numbers Excel put in little square ASCII signs. I
tried fromating cells but nothing worked...
To make thing even more interesting ... i tried the same thing on my
coworkers pc and it worked perfectly, without any formating ...?!?
If anyone has any ideas why this is happening or how to fix this
please help...
Thanx in advance,
lp John
I made a query view on sql server. Among other fields there was also a
datetime field. Then i imported this data to Excel using a Pivot table
(get external data). I wanted to manipulate dates using "Group and
Outline" however when i tried, dates were all wrong and grouping was
also wrong. The date format should be like "04.05.2003" but instead od
dots "." between numbers Excel put in little square ASCII signs. I
tried fromating cells but nothing worked...
To make thing even more interesting ... i tried the same thing on my
coworkers pc and it worked perfectly, without any formating ...?!?
If anyone has any ideas why this is happening or how to fix this
please help...
Thanx in advance,
lp John