PC Review


Reply
Thread Tools Rate Thread

Cell Formats

 
 
ej
Guest
Posts: n/a
 
      2nd Jul 2008
I have been trying to enter 01-63 as an exaple and it always changes it into
a date like jan-63. I have tried everything i can think of to fix it. Any
suggestions please let me know
 
Reply With Quote
 
 
 
 
tim m
Guest
Posts: n/a
 
      2nd Jul 2008
formatt the cells (or columns) you will be entering the data into as 'text'
before you start entering data.

"ej" wrote:

> I have been trying to enter 01-63 as an exaple and it always changes it into
> a date like jan-63. I have tried everything i can think of to fix it. Any
> suggestions please let me know

 
Reply With Quote
 
Pete_UK
Guest
Posts: n/a
 
      2nd Jul 2008
Enter it with an apostrophe in front, i.e.

'01-63

and Excel will take this as a text value (the apostrophe will not show
in the cell).

Alternatively, pre-format the cell as Text beforehand, and then you
can enter it as 01-63.

Hope this helps.

Pete

On Jul 2, 6:21*pm, ej <e...@discussions.microsoft.com> wrote:
> I have been trying to enter 01-63 as an exaple and it always changes it into
> a date like jan-63. *I have tried everything i can think of to fix it. *Any
> suggestions please let me know


 
Reply With Quote
 
vezerid
Guest
Posts: n/a
 
      2nd Jul 2008
Two choices:
Either precede your entry with an apostrophe '. The apostrophe will
not show in the cell, only the formula bar.
Or give the cell the number format of Text

HTH
Kostis Vezerides

On Jul 2, 8:21 pm, ej <e...@discussions.microsoft.com> wrote:
> I have been trying to enter 01-63 as an exaple and it always changes it into
> a date like jan-63. I have tried everything i can think of to fix it. Any
> suggestions please let me know


 
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
Inheriting cell formats when using absolute cell references DJFudd Microsoft Excel Misc 1 22nd Jul 2009 12:35 PM
"too many different cell formats" after EditClearing lots Formats RR Microsoft Excel Crashes 1 18th Oct 2008 01:24 AM
Copy and link formats from cell to cell Kathrine J Wathne Microsoft Excel Misc 0 15th Jun 2006 03:54 PM
Get Too Many Cell Formats when trying to paste data to cell =?Utf-8?B?TWFyc2h5?= Microsoft Excel Crashes 0 15th Jan 2006 07:02 PM
Formats: Too many different cell formats error message vvaidya@pol.net Microsoft Excel Programming 3 1st Feb 2005 01:34 AM


Features
 

Advertising
 

Newsgroups
 


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