| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to turn off Auto editing of cell
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.... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to turn off Auto editing of cell
In B1: =SUBSTITUTE(A1," to ",":")
drag the Fill Handle to copy as far as needed "anil" wrote: 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.... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to turn off Auto editing of cell
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 "anil" wrote in message ps.com... 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.... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to turn off Auto editing of cell
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 anil wrote: 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.... -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Sum, how do you turn it off?? | Excel Worksheet Functions | |||
| how do i turn off auto fill? | Excel Discussion (Misc queries) | |||
| how do i turn off debugger and script editing | Excel Discussion (Misc queries) | |||
| turn off auto subtotal | Excel Worksheet Functions | |||
| auto format - how do I turn it off? | Setting up and Configuration of Excel | |||
Linear Mode
