Prev: How reliable is this site!
Next: delete cells containing zero after a cell containing a value
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) 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



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:1e0151bb-b756-4a5c-addc-78182099a64d(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) 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
>
>
>

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