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) key-in 5/35 and hit "Enter" key will become 1/7 fraction value
2) key-in 5/5 and hit "Enter" key will become 1 whole number

Do not change the original fraction as follows:-

1) key-in 5/35 and hit "Enter" key will maintain as 5/35 fraction
value
2) key-in 5/5 and hit "Enter" key will maintain as 5/5 fraction value

Regards
Len