InaPlex
»
InaPlex
»
KnowledgeBase
»
Excel numbers as text
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: - 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.
- 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
|
InaPlex
»
InaPlex
»
KnowledgeBase
»
Excel numbers as text
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.