Search Results

Search found 7704 results on 309 pages for 'excel 2011'.

Page 49/309 | < Previous Page | 45 46 47 48 49 50 51 52 53 54 55 56  | Next Page >

• Stop excel from converting copy-pasted number/text values to date

  - by Tomas

  I'm copy-pasting some data from html table into excel. But excel automatically converts some text or number values to date! When I change the format, the number is perversed, the number is something like 4112523 (excel probably interprets the cell as date and then converts to number or something like that...) There is a trick for importing CSV…

  Read the article

• Excel: How do I copy hyperlink address from one column of text to another column with different text?

  - by OfficeLackey

  I have a spreadsheet where column A displays names in a certain format. There are 200-odd names and each has a different hyperlink (which links to that person's web page). I want to reformat the name order so it is "Surname, Name" rather than "Name Surname" and retain the hyperlink in the newly formatted column. I have achieved "Surname, Name"…

  Read the article

• Excel chart: How to reverse the X axis of time series data

  - by JohnnyLambada

  In Excel 2003, I have a time series from a financial report that goes something like this: 2007 2006 2005 Amount 300 200 100 I want to create a graph of the time series that looks something like this (please excuse the ugly ascii graph): 300| .x | ... 200| .x.. | ... 100| x …

  Read the article

• How do I put logical operators in an Excel =IF Formula?

  - by Brian Hooper

  I'm trying to enter a formula to display text according to an IF condition. The best I can manage is something like... =IF(myval>=minval & myval <= maxval, "OK", "Not OK") But this appears to work exactly wrongly, displaying OK when myval is out of range and Not OK when it is in range. How do I specify the logical AND correctly?…

  Read the article

• Format Excel cells to display as '##:##:##'

  - by David Gard

  I'm trying to format cells in Excel so that they display the total duration of phone calls as hh:mm:ss, but Excel is giving me errors. Sometimes durations are only mm:ss (49:10), or even just ss (35), and I need them by default to change to 00:49:10 and 00:00:35 respectivly. However, when I select 'Custom' on the 'Number' tab when…

  Read the article

• Is it possible to use images in an Excel IF statement?

  - by dunc

  Quite a simple one here, but I guess the answer will be a resounding no! I have a few symbols, basic clip-art, which I'd like to display depending on certain information. At the moment, I'm using this statement to display Y or N: =IF(B2>0,VLOOKUP(B2,'Student Data'!$A$2:$L$36,8),"") It's a simple lookup which checks another…

  Read the article

• Excel DataFlow UML Viewer/Navigator/Visualiser tool/ hint

  - by Arjang

  Not sure what to call it but, is there a birds eye view tool for excel to show the data flow between excel sheets/cels etc? I have inherited some huge reports and looking at each cell to see where it's data comes from or what sheet/cell dependencies it has is a nightmare. Or even just something with excel that show the…

  Read the article

• Is there anyway to make particular-selected cells in MS Excel as read-only?

  - by infant programmer

  By LOCKING the cells, and switching protection on will make whole file read-only .. But I want to make only few/selected cells as read-only .. that means, those cells cannot be edited anymore .. Is there any facility as such pre-defined in MS-office .. Please let me know if you aware of this feature ..

  Read the article

• How to exempt rows from being hidden/filtered in Excel 2010?

  - by tarheel

  Consider a spreadsheet that starts looking like this: I want to be able to filter for Name 1 on the left column and have it look like this: Yes, I realize that the simple answer is to filter for Name 1 and Header, but I have other people using this spreadsheet that don't seem to get that. So, how can I make it…

  Read the article

• excel pivot tables stopped working after upgrade to office 2007

  - by some random guy

  An excel document with several pivot and lookup tables that previously worked under office xp and 2003 stopped working after an upgrade to office 2007 (linked stuff doesn't update). I originally assumed there's something disabled in 2007 that I need to turn back on, but after having opened it in excel 2007 it no…

  Read the article

• Ruby: Parse Excel 95-2003 files?

  - by Larry K

  Is there a way to read Excel 97-2003 files from Ruby? Background I'm currently using the Ruby Gem parseexcel -- http://raa.ruby-lang.org/project/parseexcel/ But it is an old port of the perl module. It works fine, but the latest format it parses is Excel 95. And guess what? Excel 2007 will not produce the Excel…

  Read the article

• SBS domain name choice

  - by sandymac

  We are about to set up SBS 2011 at my small company < 10 users. My collaborator wants to name the SBS domain "example.local" . I'm of the opinion we should name the SBS domain "corp.example.com" and setup DNS so the "corp" record is a NS record to the SBS server's private IP. FYI: "Example.com" isn't the real…

  Read the article

• Getting Outlook notification on more than just Inbox messages

  - by blackwing

  Outlook can notify the user every time a new email is received in the Inbox folder. (On Mac it also shows the # of unread messages in the Inbox). I have some server rules setup which makes certain emails go straight to a custom folder. I was wondering if there is an easy way to make Outlook do this before new…

  Read the article

• Multiline Equation won't center and align on equals sign

  - by cubicleWar

  I have a multiline equation which I wish to align on the '=' and center the equation block on the page. I have selected align on '=' and center as a group, however the equation group becomes left justified on the page (and aligned on the =). No matter what I do I cannot get it to concurrently center the group…

  Read the article

• Refreshing imported MySQL data with MySQL for Excel

  - by Javier Rivera

  Welcome to another blog post from the MySQL for Excel Team. Today we're going to talk about a new feature included since MySQL for Excel 1.3.0, you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version…

  Read the article

• Using SDL Tridion 2011 Core Service to create Components programatically

  - by user1428019

  I have seen some of the questions/answers related to this topic here, however still I am not getting the suggestion which I want. So I am posting my question again here, and I would be thankful for your valuable time and answers. I would like to create “Component, Page, SG, Publication, Folders “ via…

  Read the article

• how to save excel file in sqlserver 2005

  - by Anish Mohan

  Hi, I have a table in which there are two columns : 1. import type, 2. Excel import template. The second column - "Excel import template" should store the whole excel file. How would I save excel file in databse...can I use binary datatype column, convert excel file to bytes and save the same ? …

  Read the article

• how to save excel file in MS SQL Server 2005

  - by Anish Mohan

  I have a table in which there are two columns : 1. import type, 2. Excel import template. The second column - "Excel import template" should store the whole excel file. How would I save excel file in databse...can I use binary datatype column, convert excel file to bytes and save the same ? …

  Read the article

• Convert mht\pdf\excel and encoding

  - by CoLLiDeR

  I am looking for a .net library that can help me do one of the following: 1. Convert an MHT file to PDF 2. Convert between pdf versions 3. Change a pdf file encoding 4. Convert an MHT to an Excel file 5. Convert a MIME version of excel (an Excel file that is readable via notepad) to a binary…

  Read the article

• How to disable Excel's auto recognition of numbers and text

  - by Yin Zhu

  I used Python to generate a CSV file. But when I open it in Excel, Excel will auto recognize a string into a number if it could be converted. e.g.33E105, which is actually an ID, not a number. How to disable this in Excel while opening a CSV file? Or I need to resort to a excel-python…

  Read the article

• How to determine the format of Excel file in Java?

  - by Samuh

  I am working on a light weight Java client library for Android mobile platform that can read and write to Excel files in .xls(BIFF) and Office 2003 XML format. No sooner we decided to start than we got stuck with a basic question. How do we determine the format of the excel files in…

  Read the article

• How to validate Excel range that it has error/warning using C#?

  - by Ekkapop

  I want to validate range of excel worksheet (e.g. "A10:B20") to check that is it has error or NA value or not? How to do that in C#? P.S. I find similar topic (Excel range usage question (cell error checking)) but that topic is not thing I need.

  Read the article

• How to validate Excel range that it has error/warning using .NET?

  - by Ekkapop

  I want to validate range of excel worksheet (e.g. "A10:B20") to check that is it has error or NA value or not? How to do that in C#? P.S. I find similar topic (Excel range usage question (cell error checking)) but that topic is not thing I need.

  Read the article

• Using Excel.Application in ASP where Excel is installed on Client Machines instead of the Server.

  - by simonalexander2005

  Hi, I have a server with an asp page on it that generates a report in Excel, using the Excel.Application object. Normally, Excel would have to be installed on the server to work. I was wondering, however, if it is possible to utilise the excel install on client machines to do this…

  Read the article

• Is there a way to capture HotKeys/Shortcuts in Excel VSTO using only C# and no VBA?

  - by Phobis

  So I want to capture some key-commands in our Docuement-level Excel VSTO addin. I can't seem to find a way to do it, other than to use VBA and have our addin talk to the VBA. Any help/examples would be greatly appreciated. I am using Excel 2007.

  Read the article

< Previous Page | 45 46 47 48 49 50 51 52 53 54 55 56  | Next Page >