I'm on a mac. A colleague sent me an Excel file (.xls) which I looked at in Excel 2011. It looks fine. I would like to save the file in some sort of text format, so that I can open Terminal and look at it in less. I realize that the columns won't align nicely, that's fine. What I don't want are all the weird characters that show up (from differently formatted line endings, etc). I've tried saving as "Tab delimited text," but that has the problem with the line endings. Which format should I use?
posted by bluefly
on Aug 16, 2012 -
9 answers
Excel is treating me like a child because it thinks I can't tell the difference between .csv and .xlsx. It's wasting my time. Help?
[more inside]
posted by ootandaboot
on Dec 5, 2011 -
9 answers
Excelfilter: This may be a long shot, but..... Is there a quick way of formatting a table to group like records under a single heading?
[more inside]
posted by Kurichina
on Jul 29, 2010 -
14 answers
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
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
