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