Table in Noventri Suite doesn't match Excel file

[sirluke34]

Hello,
I have a few pages in a Noventri project that are pulling "databased" text fields from an Excel file. Each page will have text objects that reference different Excel "sheets/tabs" by column/row. A couple of my pages are working correctly, meaning pulling data and updating properly.

One page however, doesn't match the Excel file. When I link up the Excel file to the text file, I can see data in any tab using the advanced properties of the text box, except for this one. I do actually see data, but all data is 0.00, not populated like it is in Excel. I have tried recreating the page and the text fields in Noventri.

Below are some pics for reference. Is there anything I've overlooked?

[Trent S]

Hello sirluke34,

This may be caused by the format that the cells containing those dollar values are in.

What format is your top row (containing column header names) in, and what format are your other cells (containing dollar values) currently in?

Kind Regards,

[sirluke34]

Thanks Trent - this seemed to be the culprit. They were all formatted as a number/currency. I changed the top header row to text and the rest as a number and it worked just fine.

Thanks for the quick response.