From: Len on 30 Mar 2010 01:18 Hi, In Excel or VBA function, after formatting cell to fraction, is there anyway to stop Excel from automatically changing a fraction from what you type in a field? and do not convert to text ( ie put an inverted comma before fraction or press space bar before fraction ) as this fraction will be used for computation later E.g. 1) keyin 5/35 and hit "Enter" key will become 1/7 fraction value 2) keyin 5/5 and hit "Enter" key will become 1 whole number Do not change the original fraction as follows: 1) keyin 5/35 and hit "Enter" key will maintain as 5/35 fraction value 2) keyin 5/5 and hit "Enter" key will maintain as 5/5 fraction value Regards Len
From: ozgrid.com on 30 Mar 2010 01:36 The only way I can think of is enter your fraction and custom format the cell as "5/35" Doesn't account for any value change, though.  Regards Dave Hawley www.ozgrid.com "Len" <ltong2000mal(a)yahoo.co.uk> wrote in message news:1e0151bbb7564a5caddc78182099a64d(a)y33g2000pre.googlegroups.com... > Hi, > > In Excel or VBA function, after formatting cell to fraction, is there > anyway to stop Excel from automatically changing a fraction from what > you type in a field? and do not convert to text ( ie put an inverted > comma before fraction or press space bar before fraction ) as this > fraction will be used for computation later > > E.g. > 1) keyin 5/35 and hit "Enter" key will become 1/7 fraction value > 2) keyin 5/5 and hit "Enter" key will become 1 whole number > > Do not change the original fraction as follows: > > 1) keyin 5/35 and hit "Enter" key will maintain as 5/35 fraction > value > 2) keyin 5/5 and hit "Enter" key will maintain as 5/5 fraction value > > Regards > Len > > >
From: Len on 31 Mar 2010 23:12 Hi Dave, Thanks for your suggestion I try to format cell as text and then reformat it to value, that cell still doesn't account for any value Regards Len

Pages: 1 Prev: How reliable is this site! Next: delete cells containing zero after a cell containing a value 