Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
ipadmin  
#1 Posted : Thursday, August 20, 2015 10:43:55 AM(UTC)
ipadmin

Rank: Administration

Groups: Administrators
Joined: 8/17/2015(UTC)
Posts: 22

Was thanked: 2 time(s) in 2 post(s)
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"
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF | YAF © 2003-2020, Yet Another Forum.NET
This page was generated in 0.072 seconds.

Notification

Icon
Error