Excel thinks it's smarter than me

[Patchworkblue]

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]

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]

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>