Do you have any Excel OCD habits?

[Domski]

ROFLMAO

Dom

 

[arkusM]

I don't mind a bit of length in a file name. I don't mind embedding a date in the name. But, if yer gonna put a date in the name then fer heaven's sake, use an intelligent format. In the U.S. you usually see

• MyFile 11-22-2010.xlsx
• MyFile 12-22-2010.xlsx
• MyFile 01-22-2011.xlsx

which sorts all wrong in Windows Explorer. For some reason it appear to be exceedingly difficult for people to use a format that would sort properly...

• MyFile 2010-11-22.xlsx
• MyFile 2010-12-22.xlsx
• MyFile 2011-01-22.xlsx

Ha Totally....
I force myself to use YY-MM-DD file prefixs SOOOO much easier to find stuff...

 

[steve case]

Ha Totally....
I force myself to use YY-MM-DD file prefixs SOOOO much easier to find stuff...

Why the dashes?

Today is 20101129 or 101129 if your files don't go back to 091231 and before.

I hate the Excel date feature. As is often the case I download some data off
the 'net and Excel chooses to regard it as a date. Very frustrating. I'm told I
can't turn the @#% thing off.

 

[arkusM]

Why the dashes?

Today is 20101129 or 101129 if your files don't go back to 091231 and before.

I hate the Excel date feature. As is often the case I download some data off
the 'net and Excel chooses to regard it as a date. Very frustrating. I'm told I
can't turn the @#% thing off.

Habit I guess... and i found it a little easier read. no good reason really.

 

[MrKowz]

Another OCD of mine I just realized today is that when I'm working in a sandbox (blank spreadsheet) to test formulas and such for the forums... I do often resize my columns to varied widths. When I clear the sheet of all data/formulas, I select all cells and resize to the default (8.43) size. When I see cells that are really really wide or really really narrow with no data in them, it drives me bonkers.

 

[Greg Truby]

Why the dashes?

In my case - for others. I'd see a string of numbers like that and immediately think it's a date stamp, but many average office workers have harder time seeing the date w/o the dashes.

Mark, 2-year dates? Too young to remember Y2K I assume...

 

[Taul]

when I'm working in a sandbox (blank spreadsheet)

yeah, me too, obsessive about column widths.
only I call it "sandpit" cos that's where kids play, right! at least that’s what it was called when I was a kid.

My other OCD behaviour relates to the colour of the text for data input pages
Black for normal typed data
Dark blue for drop down data
Dark Grey for cells with formula

Only use a coloured background for highlighting cells on report pages, then only pastel shades so they print ok on a black ink printer, still use colour just for the odd report that actually gets printed in colour.

 

[steve case]

...many average office workers have harder time seeing the date w/o the
dashes...

Oh without a doubt! I meant for just my use. When I was working and
building all sorts of toys for people to use out on the factory floor, I made
darn sure it was blue collar friendly.

White collar friendly was another matter (-:
.
.
.
.

 

[arkusM]

In my case - for others. I'd see a string of numbers like that and immediately think it's a date stamp, but many average office workers have harder time seeing the date w/o the dashes.

Mark, 2-year dates? Too young to remember Y2K I assume...

Haha, I remember... Oh wait nothing happened. and since I doubt any of my stuff will be around for the next eighty or so years when the '90s show up again I figure I'm good.

I do remember playing with these radio-type phones called Mike at midnight that new years (wow that was TEN years ago)with my buddy(an IT guy incidentally) seeing if they would work, being that they were on a digital network and all.

As for seeing the time stamp deal. Saddly I am just an average office worker.

 

[Norie]

arkusM

Don't keep us in suspense - did the phones work at midnight?

Or did you perhaps forget to check?