Deadly Habits in Excel 9

[fumei]

What a great thread...time to add it to my Archive.

Gerry

 

[fumei]

Shoot, and give another star, which I forgot to do the first time.

Gerry

 

[bluedragon2]

These rule are ridiculous.. I would never follow them

Great write-up, should put it in the FAQ's...

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[GSCaupling]

Thanks to Fumei for pointing out (to me, at least) the archive feature here. That's a cool feature! My yellow post-it notes were getting really hard to organize.

GS

[small][navy]**********************^*********************
I always know where people are going to sit. I'm chairvoyant.[/navy][/small]

 

[MasterRacker]

This extends the item about not mixing data types in a column: it can happen to you behind the scenes and you may not be aware of it:

http://www.theregister.co.uk/2004/07/16/excel_vanishing_dna/

In other words, be very wary of auto-format. Maybe just turn it off. As we all know data should be independent of presentation.

PS. If you import a spreadsheet into a database table, you'll find out right away if you have mixed data types in a column.

Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]