How do I fix this? I "imported" a table from a PDF (big mistake). In the pdf, the dates were formatted as AA-BB, where AA was the month and BB was the year. Excel interpreted that as AA is the month and BB is the day, and gave them all 2013 as the year. So now the date reads as 11-Jan instead of Jan 2011. I no longer have access to the original dataset because I only just noticed the mistake. I am using Excel 2010 on Windows.
posted by rebent
on Aug 26, 2013 -
I have a 100-page Word document full of miscellaneous content from different websites.
Unfortunately, after each section taken from a website, there's basically a citation for where the content was taken from that contains the URL for the website.
I need to find a way to find all these hyperlinks and delete them completely from my document. They're all from different websites, so really, the only commonality is the "http://" part.
posted by beammeup4
on Jul 19, 2013 -
Switching from Word for Mac 2004 to Word for Mac 2011. Formatting and compatibility issues. Really truly clueless. Help? [more inside]
posted by greta simone
on Jan 18, 2012 -
When I enable HTML in email messages in Entourage, the email and signature both become double-spaced. How can I enable HTML and send single-spaced emails? [more inside]
posted by nosila
on Sep 19, 2010 -
Quick and easy solution for reformatting Word documents from inconsistent manual formatting to Styles? [more inside]
posted by Jacqueline
on Apr 23, 2009 -
In ms word, in endnotes, there's this little two-inch
line in the upper-left corner to symbolize that you're in "footnote
land," even on the second page of the endnotes and after. It's the
same line that's at the bottom of the page before a footnote. Is
there any way to remove this line? I have a mac, but I think the same issue comes up with PCs. I need to get rid of this line to fulfill the formatting requirements to post my dissertation, so any help would be much appreciated!
posted by jefsolo
on Nov 29, 2008 -
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 -
In Microsoft Word 2003, I'm trying to format a document so that there is both one-columned and two-columned text on the same page. Whenever I apply two columns to the text I want to be in two columns, it always shunts all that text to a new page, as if I had inserted a page break. What do to? [more inside]
posted by midatlanticwanderer
on Jan 30, 2007 -
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 -
MS Word in OSX
I’m formatting my thesis and need to create a “floating page” for my figures. This is a page that inserts itself between two full pages of text, so that the text flows around the page.
Can I do this? [more inside]
posted by nprigoda
on Jul 17, 2004 -