HOW can I import a precision number

VisLord · May 24th, 2002, 12:40 PM

I am trying to import a ":" delimited text file that contains numbers with 8 place precision (ie 1020968588.84471624).

Using Text File Inport Wizard, the numbers are rounded to 5 places.

I will eventually be using a QueryTable VBA function

Tks

Jay Petrulis · May 24th, 2002, 12:55 PM

When you use the wizard, on the 2nd or 3rd step, import these columns as text. Excel will import them without loss of precision (although they will no longer be "numbers").

There will be no way to use more than 15 digits in a worksheet cell (IEEE standards used by Excel), but in VBA changing the text to decimals (use CDec) will allow you to calculate with up to 28 digits of precision, although you can still only return 15 to Excel proper.

HTH,
Jay

VisLord · May 24th, 2002, 01:23 PM

Thanks for the quick responce, Jay

Haven't tried it yet, but if I can get it in, I can do whatever....

Thanks again...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 12:40 PM	#1
VisLord New Member Join Date: Apr 2002 Posts: 30	I am trying to import a ":" delimited text file that contains numbers with 8 place precision (ie 1020968588.84471624). Using Text File Inport Wizard, the numbers are rounded to 5 places. I will eventually be using a QueryTable VBA function Tks

May 24th, 2002, 12:55 PM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	When you use the wizard, on the 2nd or 3rd step, import these columns as text. Excel will import them without loss of precision (although they will no longer be "numbers"). There will be no way to use more than 15 digits in a worksheet cell (IEEE standards used by Excel), but in VBA changing the text to decimals (use CDec) will allow you to calculate with up to 28 digits of precision, although you can still only return 15 to Excel proper. HTH, Jay

May 24th, 2002, 01:23 PM	#3
VisLord New Member Join Date: Apr 2002 Posts: 30	Thanks for the quick responce, Jay Haven't tried it yet, but if I can get it in, I can do whatever.... Thanks again...