LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default 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....

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Sum, how do you turn it off?? JY Excel Worksheet Functions 4 April 21st 23 02:58 PM
how do i turn off auto fill? nia1989 Excel Discussion (Misc queries) 3 February 10th 07 03:25 PM
how do i turn off debugger and script editing CAL-KID Excel Discussion (Misc queries) 3 January 11th 07 04:36 AM
turn off auto subtotal jenn Excel Worksheet Functions 1 November 29th 05 03:53 AM
auto format - how do I turn it off? TooManyPutters Setting up and Configuration of Excel 1 July 13th 05 05:19 PM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"