to turn off Auto editing of cell

[anil]

HI all,

I have a column entry of ratios as

1 to 1
1 to 1.1
1 to 1.2
..
..
..
i need to change the cell entries to
1:1
1:1.1
1:1.2
..
..
..
But when i replace the cell the cell format will automatically change
to Date and display 1:01...

Please help me on that....

 

[Guest]

In B1: =SUBSTITUTE(A1," to ",":")
drag the Fill Handle to copy as far as needed

 

[R1C1]

That entry would be interpreted by Excel as time in hours and minutes. I
believe you will need to format the cell as text, before making the entry,
to achieve the desired visual effect.

Regards,

Alan

 

[Dave Peterson]

You can try this:

Tools|Options|Transition Tab|Check Transition Formula Entry
Then do the Edit|Replace
Then Tools|Options|Transition Tab|Uncheck Transition Formula Entry