General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2003 Server
>We update customer price lists from Excel spreadsheets. Over the years I have been able to read any of the values that might be in a cell but this one has me pulling my hair out.
>
>The part numbers are in a format of 999.999 Most of the time but sometimes 999.999ABC and sometimes 999.9999. The problem is that although the part number shows as 123.456 or 123.4567 in the cell, TRANSFORM() converts it to 123.45670000000. Any ideas on how to grab the number as it should be. I can't just trim the number as the length varies and sometimes does end in 00.
There are a thousand things that can go wrong importing data from Excel. (Which of course is the favored data entry method of most users). This one seems fairly simple -- don't import it as a number. Since when are part numbers numerics with decimals?
If the part number really does have decimals, well, find the original developer and shoot him.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only