BASIC accepts floating point values - you just have to declare them as such. I'm not sure about all forms of BASIC, but try a declaration with REAL or FLOAT or DOUBLE.
Plus Excel has a function INT() which finds the integer part of any number [and INT(value+0.5) does rounding]. If you really are stuck with a program that only handles integers and your values are so small that rounding will introduce errors, you might multiply the numbers by some value such as 1000 before rounding. Bill Silvert ----- Original Message ----- From: "Heather Hawk" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, May 31, 2006 5:15 PM Subject: Modeling in integers: exporting from excel to BASIC >I have a laaaaarge set of data that I've been working with using various > stat programs that import ASCII values from excel spreadsheets, like > PC-ORD > and JMP, but I'm trying to write a program for modeling in programs that > only accept values in integer form, like BASIC. Does anyone know a > relatively straightforward way of exporting or converting excel > spreadsheets > to be used in BASIC modeling? Any advice on this will be tremendously > helpful, as re-punching the data is out of the question! Thanks. > Heather Hawk > [EMAIL PROTECTED] >
