Prevent changing a fraction

[Len]

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

 

[ozgrid.com]

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.

 

[Len]

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