Formatting causes number loss

[Maslan]

Hi guys,
I used excel's OpenText method to load a very large text file. The source file is ok. In excel, the number 5402563000067965 is shown as 54+Exx, which is fine. When I format it as number & did a column autofit, the last number becomes 0, it now becomes 5402563000067960. Don't know whats wrong. Help??
Thanks.

 

[Tommy Bak]

Hi
Yes, Yogi. Dawe's arswer is correct.
I'm sorry I didn't express myself more clear.
regards Tommy

 

[Yogi Anand]

On 2002-03-26 20:28, Yogi Anand wrote:

On 2002-03-26 00:49, Tommy Bak wrote:
Hi maslan
if you want it treated like text then use array(242, 2 )
regards Tommy

Hi Tommy:
Would you please elaborate your point for me please!

Hi Dave and Tommy:
T H A N K S ! for your help in trying to explain it to me -- but I still need more clarification. Dave: the last column while converting TextToColumn facilitates selecting one of the options from:
General
Text
Date
Do not imort column (skip)

What I am not getting is where array(242,2)comes in. Necessary explanation with a small example will be greatly appreciated!