Hello everyone,
I have created a dashboard where I am importing data via a web service. This data is to be displayed in a spreadsheet table. One of the fields is a date. It appears as a date when using SOAP, but once you bring it into an Excel chart, it converts it to a “General” text format (ex: 40359 should be 6/30/2010). I’ve formatted those columns/fields in the Xcelsius Excel instance to be dates, but it still displays the dates as “40359” instead of “6/30/2010” etc.
Has anyone experienced this before? Is it a glitch or is there an additional step needed for the data to be formatted properly?
Thank you all ahead of time for any insights you can provide.
Benson Yee