A little problem with Excel View previous topic :: View next topic  


NFOHump.com Forum Index - Applications
Page 1 of 1
whoKnows
VIP Member



Posts: 2972
PostPosted: Wed, 29th Sep 2004 17:08    Post subject: A little problem with Excel
Hey,

i have a problem with one of those stupid MS features of Excel! I usually don't work with Excel, so i am not a genius with it and some of you might find the question stupid.

I am working with a spreadsheet and i am trying to fill in numbers like 2,5 or 2.5 or 2-3. And everytime i do that, this stupid Excel replaces this with dates. How the fuck can i turn this stupid shit off! I have tried it with turning of autocorrection, but no luck. Of course i did look that up in the help section but nothing.

Anybody can help me, TIA Smile

btw i am using Excel 2002
Back to top
€XC€PTiON™




Posts: 19
PostPosted: Wed, 29th Sep 2004 18:39    Post subject:
Here's a couple of ways to stop that behavior:

1. Select the cells you will be modifying and format it as "Text"

2. When entering the literal string resembling a number, enter ' (single quote) before the string. Example:

123.567 ---> '123.567
2-3 ---> '2-3
Back to top
whoKnows
VIP Member



Posts: 2972
PostPosted: Wed, 29th Sep 2004 19:09    Post subject:
Thanks €XC€PTiON™ Smile
Back to top
Page 1 of 1 All times are GMT + 1 Hour
NFOHump.com Forum Index - Applications
Signature/Avatar nuking: none (can be changed in your profile)  


Display posts from previous:   

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2.0.8 © 2001, 2002 phpBB Group