Excel number formats lost

Post by **utgraphics** » Wed Feb 21, 2007 3:30 am

I imported an excel file and the number formats were lost. So this > $100,000...now looks like this > 100000...which I don't want.

Any solutions?

Post by **sorin_ristache** » Wed Feb 21, 2007 4:57 pm

Hello,

The currency value is considered a number by the import operation. In the Import criteria dialog you can change the default name of the element/attribute that contains currency values in the XML result file, for example from Heading2 to CurrencyUSD. Other option is to save the Excel sheet as a CSV file and import it in oXygen as a CSV text file by going to File -> Import -> Text File and selecting comma as field delimiter in the Import criteria dialog.

Regards,
Sorin

Post by **sorin_ristache** » Fri Feb 23, 2007 3:15 pm

Hello,

Also there is a quick method for transferring the content of the Excel cells to an XML document in oXygen: in Excel click on the column header with the values that you want to transfer to the XML document, execute the Copy action, open the XML document in oXygen, switch to the Grid editor, right click on the column header of the column where you want to paste the copied content, select the Paste action. This will preserve the $ and , symbols.

Regards,
Sorin