[users] calc with fractions

2009-08-09 Thread Don VanSyckel
I have a need to use and display fractions in a calc sheet. The problem is when 7/16 is entered calc displays 4/9. In examining the underlying cell contents it does list 0.4375 which is 7/16. 4/9 is 0.... The only way I can see to solve this is by having two columns, the first

Re: [users] calc with fractions

2009-08-09 Thread JOE Conner
Don VanSyckel wrote: I have a need to use and display fractions in a calc sheet. The problem is when 7/16 is entered calc displays 4/9. In examining the underlying cell contents it does list 0.4375 which is 7/16. 4/9 is 0.... The only way I can see to solve this is by having two

Re: [users] calc with fractions

2009-08-09 Thread Don VanSyckel
Thanks, changing the format code worked. JOE Conner wrote: Don VanSyckel wrote: I have a need to use and display fractions in a calc sheet. The problem is when 7/16 is entered calc displays 4/9. In examining the underlying cell contents it does list 0.4375 which is 7/16. 4/9 is