I need a custom number format for Excel that only gives me a decimal when I need it. [more inside]
posted by lou on Apr 26, 2009 - 5 answers

Any Excel gurus in the room? I have an Excel spreadsheet with over 800 rows of data. Each row begins with a number (like 0001), and some have letters after the numbers (like 0001a). The Sort function doesn’t sort the way I’d like it to. [more inside]
posted by Milkman Dan on Apr 17, 2008 - 7 answers

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 by ChasFile on Feb 1, 2008 - 8 answers

Excel - automatically converted my numerical values - [more inside]
posted by seeminglyshy on May 14, 2007 - 8 answers

How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row. [more inside]
posted by bokinney on Mar 12, 2007 - 7 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 by RavinDave on Sep 14, 2004 - 13 answers

StupidQuestionFilter:
Microsoft Excel 2000 v 9.0 - is there some way to stop excel from automatically turning email addresses into hyperlinks? Not just turning off the 'blue and underlined' format but actually not making them links. I've done it before in other versions of excel but I can't find a way to do it in this version. Thanks!
posted by anastasiav on Jul 16, 2004 - 4 answers