Skip to Content
0
Former Member
Nov 14, 2012 at 06:05 PM

Xcelsius and date formatting

51 Views

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