Keep XML formatting

[Former Member]

I have an XML file that is produced from an external excel document that contains formatting of numbers in an accounting format. I am pulling that XML file into Xcelsius so the dashboard can be dynamically updated, but when the data is imported into Xcelsius from the XML file, the numbers lose their formatting. How can I make it so they keep it?

[Former Member]

Hi Tony,

One way to retain the formatting would be to duplicate the values in another column using the XML data as a reference and apply the formatting when you copy this data.

e.g if the XML data is been put as 100, 200, 300 you may use the default formatting by Excel or apply Concatenate function to get the desired results -

=CONCATENATE("$",A1)

100 $100

200 $200

300 $300

Hope this helps,

Ameet

[Former Member]

Hi Tony,

One way to retain the formatting would be to duplicate the values in another column using the XML data as a reference and apply the formatting when you copy this data.

e.g if the XML data is been put as 100, 200, 300 you may use the default formatting by Excel or apply Concatenate function to get the desired results -

=CONCATENATE("$",A1)

100 $100

200 $200

300 $300

Hope this helps,

Ameet