Integra for Notes Banner
  Integra Family of Products


Why are numbers being shown as text in Excel when exporting data?

When exporting from Notes using an Integra profile set to Normal Export, the value in the Excel is exported as Text instead of Number.

To solve this problem, set the field type of the affected field to Formula from the Field Formula List tab and enter the following formula which will convert the text to a number:

@TextToNumber(fieldName)

Also, make sure that the data rows for that column in the Excel template are formatted as Number.

If the data in your data is already numeric, you may get a blank value or "1.#INF". In this case, please use this formula instead:

@If(fieldName="";0;@TextToNumber(@Text(fieldName)))  

.




FAQ# 0200
Bookmark and Share

 
QUICK LINKS
 
 

 

   Shireburn Software Ltd. 2008 - 2018