PC Review


Reply
Thread Tools Rate Thread

Remove auto date function in cells

 
 
=?Utf-8?B?VEthc3Npcw==?=
Guest
Posts: n/a
 
      12th May 2006
When I type '11/12' for example in Excel 2003 it automatically changes it to
'12-Nov'. How can I remove this function? I tried endlessly to change thing
in 'options' but nothing seemed to work!

Thanks for any help
 
Reply With Quote
 
 
 
 
jkend69315@aol.com
Guest
Posts: n/a
 
      12th May 2006
Format the cell for text. (This doesn't fix cells you've already typed
in)

 
Reply With Quote
 
Alan
Guest
Posts: n/a
 
      12th May 2006
It always will do that as it sees a date,
try '11/12 the apostrophe will show in the formula bar but not in the cell,
the ' converts it to text,
Regards,
Alan.
"TKassis" <(E-Mail Removed)> wrote in message
news:EF7291DB-615E-4D64-901B-(E-Mail Removed)...
> When I type '11/12' for example in Excel 2003 it automatically changes it
> to
> '12-Nov'. How can I remove this function? I tried endlessly to change
> thing
> in 'options' but nothing seemed to work!
>
> Thanks for any help



 
Reply With Quote
 
=?Utf-8?B?Q0xS?=
Guest
Posts: n/a
 
      12th May 2006
Pre-format the cells for TEXT, or type a leading apostrophe in front of your
11/12

Vaya con Dios,
Chuck, CABGx3



"TKassis" wrote:

> When I type '11/12' for example in Excel 2003 it automatically changes it to
> '12-Nov'. How can I remove this function? I tried endlessly to change thing
> in 'options' but nothing seemed to work!
>
> Thanks for any help

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i remove the auto date function from a cell to allow # rang SKJ18 Microsoft Excel Misc 2 8th Jan 2008 10:26 AM
My Auto Sum Function is not Automaticlly summing the cells =?Utf-8?B?Q2hyaXN0aWU=?= Microsoft Excel Worksheet Functions 1 7th Nov 2006 02:46 AM
Auto Protecting cells & auto filling date ccarmock Microsoft Excel Misc 7 30th Sep 2005 10:21 PM
remove date auto completion jesse Microsoft Word Document Management 0 15th Aug 2003 06:16 PM
Re: remove date auto completion Suzanne S. Barnhill Microsoft Word Document Management 0 15th Aug 2003 05:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:07 PM.