Prevent changing a fraction

  • Thread starter Thread starter Len
  • Start date Start date
L

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
 
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.
 
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
 
Back
Top