Forums

A common problem when reading data from Excel is that numbers may be formatted as text, but are still really numbers and are treated as numbers when read by Inaport.

The most common example is US zip codes. In Excel, they look like "12345" or "00123", but when read by Inaport they come through as "12345.0" or "123.0".

In Excel, even if a number is formatted as text it is still a number. You have two options:

1. In Excel, add another column and put in the formula "=text(a1, "00000")" (without the surrounding double quotes)
   This will convert the contents of cell a1 to true text, which Inaport can then read as text. Obviously change the cell reference to fit your spreadsheet.
   
   
2. In Inaport, use the n2s() function to convert the number to a string in the correct format:
   n2s(#myZipCode, "00000")
   This will convert the number 123.0 to text "00123"