Excel thinks it's smarter than me

Patchworkblue

Distinguished
Aug 12, 2003
8
0
18,510
0
But it's not!

I want to fill fields with data such as 4-7, or 5-9, but whenever I do, Excel automatically changes them to 7-April and 9-May. ARGH! It's driving me insane, and I can't figure out how to fix it! I'm pored through all the autoformat-related help files, but there is nothing that has worked. Can anyone help me?

Women--can't live with them, can't have heterosexual same-species intercourse without them.
 

Auburn9698

Distinguished
Feb 19, 2003
101
0
18,630
0
Format the cells to text.
Highlight cells. Right-click on them. Select "Format cells." Select "text" on the Number tab.

<font color=blue>War</font color=blue> <font color=orange>Eagle</font color=orange>
"Operation Can't Do Nuthin' About It is now in effect!" -Flavor Flav
 

Ned_Flanders

Distinguished
Jan 30, 2004
87
0
18,580
0
it sounds like Excel is smarter than you :tongue:

_______________________
<A HREF="http://www.moviewavs.com/MP3S/TV_Shows/Simpsons/flanderssong.mp3" target="_new">Audio Sig</A>
 
Thread starter Similar threads Forum Replies Date
FireFighter1215 Apps General Discussion 2
B Apps General Discussion 2
N Apps General Discussion 1
S Apps General Discussion 5
N Apps General Discussion 2
L Apps General Discussion 5
B Apps General Discussion 4
K Apps General Discussion 1
R Apps General Discussion 1
7 Apps General Discussion 37
J Apps General Discussion 11
E Apps General Discussion 15
L Apps General Discussion 5
S Apps General Discussion 1
A Apps General Discussion 1
E Apps General Discussion 1
T Apps General Discussion 1
B Apps General Discussion 1
B Apps General Discussion 23
B Apps General Discussion 2

ASK THE COMMUNITY