[X-Apps] AppleWorks 6.2.4 spreadsheet

[David M. Shindell]

On 06 Dec 2003, at 8:54 AM, Ken Philbrick wrote:
> I have done something stupid in AW 6 and cannot locate the source of 
> trouble. I have a spreadsheet which is used to record software 
> registration numbers and has never contained any arithmetic functions. 
>  I just inserted a row of cells for a new app and found that it 
> insists on making hash of the number. Entering 11 digits is fine, but 
> entering the 12th digit turns into "1.1111111111e+11"  I have (i) 
> pitched the pref files; (ii) turned off auto-calculate; (iii) deleted 
> and recreated the row of cells; (iv) checked every last control and 
> preference known to man; and (v) cussed. This simple spreadsheet has 
> been used for several years and it has never been a problem. What have 
> I done wrong?

Ken,

I think that you have the cells selected with format "General" or 
"Number".  I would suggest that you set the format of the cells to 
"Text" so that it doesn't treat them as a number and convert them to 
scientific notation if the number of digits is too large to display.