Welcome to WebmasterWorld Guest from 3.227.208.153

Forum Moderators: open

Message Too Old, No Replies

Excel Question

How to keep it from autodating

     
1:37 am on Apr 25, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:July 18, 2002
posts:2312
votes: 42


I have a tab delimited file I am working on in excel where I need to put a number like 1-5 in a cell. Excel keeps auto changing it to Jan-05.

I tried adding a ' to the begining, which works while I am working on the file, but when I open it later, it returns to making it Jan-05.

I have also tried changing the format of the cells. No good there either.

Does any body know how to keep excel from being so d@mn helpful? I don't want to put a date in, I just want to put a number range in.

Dear Microsoft: It's not help if it's not asked for.

3:16 am on Apr 25, 2005 (gmt 0)

Senior Member from CA 

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:Nov 25, 2003
posts:1349
votes: 441


Bet you just love that darling little paperclip too :-)

I only know two methods:
* One: format cell as text.
* Two: delimit the number like "1-5" or (1-5).

If anyone knows a better way I liked to know too.

5:40 am on Apr 25, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Sept 7, 2003
posts:1408
votes: 0


>> but when I open it later

How are you saving the file? I believe CSV will strip out any cell formatting.

3:44 pm on Apr 25, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 27, 2002
posts:1422
votes: 0


Can you save it as a tab-delimited text file? That will give you the option to determine formatting when you open the file.
5:31 pm on Apr 25, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Feb 13, 2004
posts:77
votes: 0


just put a single quote ' in front of what you want to enter. Then excel wont auto-format it, works with everything.
7:17 pm on Apr 29, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:July 29, 2003
posts:149
votes: 0


Select the cell or range or whatever and say Edit ¦ Clear Formats.
10:56 pm on Apr 29, 2005 (gmt 0)

New User

10+ Year Member

joined:July 28, 2004
posts:31
votes: 0


Format the cell as text before you enter the data.

That paperclip what a character eh? Have you seen this video?

[2atoms.com...]

"It looks like you're writing a letter".

<lawman edit> Warning, video contains coarse language </lawman edit>

[edited by: lawman at 9:21 am (utc) on April 30, 2005]