in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.

Excel numbers as text

Last post 05-07-2008 10:21 by admin. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 05-07-2008 10:21

    • admin
    • Top 10 Contributor
    • Joined on 06-10-2007
    • Posts 63

    Excel numbers as text

    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"
    Filed under:
Page 1 of 1 (1 items)
InaPlex Limited 2008