|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
04-25-2004, 08:35 AM
|
#1 |
|
GFX Techman
Join Date: Jan 2004
Location: The kingdom United
Posts: 1,316
|
help me or I will destroy excel
Every time that I put a sequence of numbers into excel (e.g. 4-1-2) it changes those numbers into a date. This does not happen in word, but only in excel and is seriously *cheesing* me off. Can anyone help me switch that function off?
 fedz
__________________
If it's broke, fix it If it ain't, overclock it ------------------------- http://img64.exs.cx/img64/309/mypc8ursmall2ts.png |
|
|
|
04-25-2004, 08:58 AM
|
#2 |
|
Member (11 bit)
Join Date: Apr 1999
Location: Quebec, Canada
Posts: 1,239
|
Change the fromat of your cells to text.
|
|
|
|
|
04-25-2004, 09:01 AM
|
#3 |
|
GFX Techman
Join Date: Jan 2004
Location: The kingdom United
Posts: 1,316
|
nope, tried that. Still changes it into a date. I tried that before and after copying and pasting. Before doesn't change it, after changes it into a really weird number (try it urself)
|
|
|
|
|
04-25-2004, 09:05 AM
|
#4 |
|
Member (11 bit)
Join Date: Apr 1999
Location: Quebec, Canada
Posts: 1,239
|
I just entered 4-1-2 into excel and it gave me 04/01/2002.
Then I changed the format of the cell to text and re-entered the same thing and it stays as 4-1-2. |
|
|
|
|
04-25-2004, 02:05 PM
|
#5 |
|
GFX Techman
Join Date: Jan 2004
Location: The kingdom United
Posts: 1,316
|
I have a list of values to input and it doesn't work. I've tried exactly as you describe but it doesn't work with more than one value. Is there any way apart from editing each cell individually? I don't understand why excel forgets about the original number and changes the (now) date to 37260. I mean, how stupid can it get?
|
|
|
|
|
04-25-2004, 03:28 PM
|
#6 |
|
Member (13 bit)
Join Date: Nov 1999
Location: Mt Washington, KY
Posts: 4,927
|
Try using Format for the column or row.
Chas
__________________
I may not be much, but I'm all I think about. |
|
|
|
|
04-25-2004, 03:52 PM
|
#7 |
|
GFX Techman
Join Date: Jan 2004
Location: The kingdom United
Posts: 1,316
|
tried that too sorry
 This really is driving me crazy |
|
|
|
|
04-25-2004, 05:06 PM
|
#8 |
|
Member (11 bit)
Join Date: Apr 1999
Location: Quebec, Canada
Posts: 1,239
|
If you select the column or row and then set the format, it will work. You are not formatting the range properly
|
|
|
|
|
04-25-2004, 05:13 PM
|
#9 |
|
Member (11 bit)
Join Date: Dec 2001
Location: Shakopee MN
Posts: 1,293
|
Changing the format to text does indeed change the 4-1-02 to a number, I forget the exact definition but it is something like the number of days since 1/1/1900 that the date you typed was. You can retype the 4-1-02 over this weird number and it will stay as you typed.
To avoid the issue type the apostrophe (right to the left of the enter key) before typing in the data and this over rides the auto replace feature I think that fixing this is not an excel but a windows change in the regional settings area.
__________________
Never Argue With An Idiot. They'll Drag You Down To Their Level And Then Beat You With Experience. |
|
|
|
|
04-26-2004, 10:45 AM
|
#10 |
|
GFX Techman
Join Date: Jan 2004
Location: The kingdom United
Posts: 1,316
|
Thanks. If anyone hears of a permanent solution that doesn't involve retyping the whole list tell me!
|
|
|
|
|
05-04-2004, 05:14 PM
|
#11 |
|
Supergeek in training
Join Date: Apr 2004
Location: UK
Posts: 1,690
|
If memory serves me right from my IT classes in school, you type in the value, go to Format>Cells, then find the tab which has the value changing section, e.g converting the value into curreny, there should be a "Normal" option, click that and see what happens. If I just echoed what the others said, forgive me.....
__________________
Pure geek and proud. "Success is not final and failure is not fatal. It is the courage to continue that counts." - Winston Churchill ------------------------------------------------------------------------------------------------- |
|
|
|
|
05-06-2004, 02:05 PM
|
#12 |
|
GFX Techman
Join Date: Jan 2004
Location: The kingdom United
Posts: 1,316
|
yeah, sorry, tried that
bring on sp3/longhorn with better excel formatting options! |
|
|
|
|
05-06-2004, 03:56 PM
|
#13 |
|
Certified Audio Nut
Join Date: Jul 2003
Location: Washington State
Posts: 7,214
 |
What version of Excel are you using?
__________________
"I'm not lying. I'm writing fiction with my mouth." - Homer Simpson My Miscelaneous Gallery ASUS P7P55D PRO / Intel Core i7 860 / 8GB Mushkin DDR3 1600 RAM / OCZ Vertex 2 120GB SSD / Seagate 1TB 7200.12 / Asus Radeon 5870 1GB / LG Super-Multi 22x SATA DVD-RW / Windows 7 Home Premium 64bit / Cable Modem / HT Omega Striker 7.1 Sound Card / FSP 700W PSU / Logitech MX1000 Wireless Laser Mouse / Asus 24" 16:9 LCD w/Webcam / Axiom Audiobyte 2.1 Speakers |
|
|
|
|
05-06-2004, 04:01 PM
|
#14 |
|
GFX Techman
Join Date: Jan 2004
Location: The kingdom United
Posts: 1,316
|
Dont really know. Im using xp home/office xp with frontpage created November 2002
|
|
|
|
|
05-06-2004, 05:17 PM
|
#15 |
|
Certified Audio Nut
Join Date: Jul 2003
Location: Washington State
Posts: 7,214
|
I have Office XP so I am assuming I have the same version of Excel. I managed to solve this by selecting the cells BEFORE typing then going to Format > Cells (CTRL-1) and under the number tab select "Text". After that, when I type something like 4-2-1 it stays that way. I don't see why it wouldn't work for you.
|
|
|
|
|
05-07-2004, 04:06 AM
|
#16 |
|
Member (11 bit)
Join Date: Apr 1999
Location: Quebec, Canada
Posts: 1,239
|
If you already entered your data and it automatically converted to a date and then you set the format of the cells to text, then this will not work. You have to set the format of the cells first to text then enter the data.
|
|
|
|
|
05-07-2004, 10:35 AM
|
#17 |
|
Member (10 bit)
Premium Member
Join Date: Aug 2001
Location: Singapore
Posts: 790
|
type "=4-2-1" (w/o the inverted commas)
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
