So, excel sees your days as months and vice-versa, which means any date with day below 12 will be recognized as a date, BUT THE WRONG DATE (month and day reversed) and any date with day above 12 won't be recognized as a date at all, because Excel sees the day as a 13th+ month. This is caused by the regional settings of your computer. When you paste data into excel it is only a bunch of strings (not dates). Excel has some logic in it to recognize your current data formats as well as a few similar date formats or obvious date formats where it can assume it is a date.
Active5 years, 6 months ago
Visit Microsoft's Office language interface pack Web page (link in Resources) and download a pack for the language you want. Save your work and close any open Office programs, and then run the download to install the language. If you are not looking to modify the format of the file, and are ONLY targeting Excel, you can use the following Excel trick to help you. Add a new line at the top of the file with the text 'sep=,' (including quotes) in order for Excel to open the file with ',' as the list separator. I don't know why, but Excel doesn't recognize the tabs anymore and I have to use the text importing tools every single time! It is odd that when I copy data from excel to notepad, the columns are separated by tab!!
On the second tab named 'Disclosures & Identification,' there is a set of merged cells at D5:G5 which hold text.
On the first tab, there is a reference to that cell. The formula being used is '='Disclosures & Identification'!D5. Instead of copying the text from the second tab's field, the formula just appears in the cell.
I have tried renaming the tab (in case the & was the problem); I have tried using the entire set of merged cells in the reference (d5:g5); I have saved the file under a new name and updated to Office 2007 format (old version was 2003, but that should have worked anyway); and I have done what I consider an appropriate amount of searching for the answer (with no luck). Does anyone have an idea as to why this might not be working? Outlook for mac signature wrapping text.
jasotasticjasotastic
closed as off-topic by Dukeling, pnuts, Jerry, Dmitry Pavliv, jonscaFeb 28 '14 at 4:08
Boot Camp For Mac Not Recognizing Windows Disk
This question appears to be off-topic. The users who voted to close gave this specific reason:
'Questions about general computing hardware and software are off-topic for Stack Overflow unless they directly involve tools used primarily for programming. You may be able to get help on Super User.' – Dukeling, pnuts, Dmitry Pavliv, jonsca
If this question can be reworded to fit the rules in the help center, please edit the question.
1 Answer
There are 2 possible things:
Make sure the format of the cell is not 'Text'. If it is, change to something else, such as 'General' and then double click in the formula bar and press enter.
Make sure that 'Show Formulas' is OFF. You can find the option under the tab 'Formulas'. Otherwise, you can use Ctrl+`