How can I conditionally format an entire row in Excel 2007 based upon the contents of a particular column in that row? [more inside]
posted on Feb 1, 2008 - 8 answers
Probably ridiculously obvious Excel question: how do I set it so that a URL is never turned into a hyperlink? [more inside]
posted on Dec 19, 2007 - 7 answers ![]()
Excel Experts: Is there a way to apply a custom formatting template to an unformatted worksheet? [more inside]
posted on Dec 12, 2007 - 4 answers
It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank. [more inside]
posted on Feb 10, 2006 - 9 answers ![]()
How do I format cells in EXCEL to accept numeric values in the form: -26:32 (or +26:32 ... that is, mm.ss but including the pos/neg sign)? I'm trying to compile a simply list of Messier Objects (astronomy) and can't figure out how to include declinations.
posted on Sep 14, 2004 - 13 answers