16 posts tagged with excel and formatting.
Displaying 1 through 16 of 16. Subscribe:

Excel imported my dates as day-month instead of year-month. How to fix?

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 - 6 answers

How to merge & combine .pdf to Excel pages

How can you merge and combine imported and converted .pdf to Excel 2007pages? [more inside]
posted by ~Sushma~ on Nov 30, 2010 - 5 answers

Copying Word tables into Excel without splitting cells into multiple rows

I need help copying a table from Word to Excel in Office 2007. Where there are hard returns within a cell in the Word table, Excel splits the table cell into multiple rows. I need Excel not to split cells in the Word table into multiple Excel rows. At the same time, I need to retain the paragraphs that appear within the Word table cells - that is, I can't just get rid of all those hard returns; the formatting must be preserved. My Google-fu is failing me rather seriously. Is there any way to do this?
posted by Dasein on Oct 18, 2010 - 8 answers

Excel 2007 Conditional Formatting

Excel 2007 conditional formatting help! [more inside]
posted by rossination on Sep 25, 2010 - 4 answers

Help me help Word and Excel play nicely together.

I'm trying to paste some text from Excel into Word. Normally when I do this, I select Paste Special > Unformatted Text so my stuff doesn't display as a table. But this time, the Excel text is already formatted with a ton of bold, italics, and underlining, and I don't know how to retain that formatting while still ditching the table. Help? [more inside]
posted by anderjen on Jun 10, 2010 - 5 answers

Excel rounding of number

Is there a way to force MS Excel to always give you four significant digits when rounding a number? [more inside]
posted by a womble is an active kind of sloth on Feb 13, 2010 - 6 answers

How do I bring HTML data into Excel?

I once used a web-based spreadsheet tool that let me copy data from pretty much any webpage into a properly formated spreadsheet. Upon pasting an entire page worth of HTML-formatted search results, for example, it prompted me for the desired cell arrangement in the spreadsheet and applied it to the entire set of data. I can't remember what it was called, I can't seem to google the right terms and this will save me (not to mention my employer) countless hours copying and pasting data this week and next. Alternatively if you have another solution, please share.
posted by reeddavid on Dec 29, 2009 - 10 answers

Is it possible to do a global change-style in Excel?

Is it possible to automate a citation style change on an entire column in Excel, or do I need to do this by hand? [more inside]
posted by min on Nov 24, 2009 - 11 answers

I have me an xls table, I do!

I have an xls file I got from a survey I created on Google docs. Now I want to make it pretty without copy-pasting every bloody cell into an Indesign document… [more inside]
posted by monocultured on May 17, 2009 - 7 answers

What Excel formula to achieve desired result?

What formulae do I need to cause Excel to highlight a cell on one worksheet if the data is found in a different worksheet? Formulae I have attempted (using named ranges) under the cut. [more inside]
posted by mccn on Apr 21, 2009 - 5 answers

How to get around Excel macro warning.

How to bypass Excel macro warning or alternative to macro. [more inside]
posted by emjay on Nov 4, 2008 - 13 answers

How can I conditionally format an entire row in Excel based upon the data in one of the columns in that row?

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

Eliminating Hyperlinks in Excel X for Mac?

Probably ridiculously obvious Excel question: how do I set it so that a URL is never turned into a hyperlink? [more inside]
posted by Dreama on Dec 19, 2007 - 7 answers

Is there such thing as an Excel formatting template thingie?

Excel Experts: Is there a way to apply a custom formatting template to an unformatted worksheet? [more inside]
posted by kmtiszen on Dec 12, 2007 - 4 answers

Carriage Returns in Excel

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 by godawful on Feb 10, 2006 - 9 answers

how can I include declinations in an Excel spreadsheet?

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

Page: 1