Office Software Forum - solved topics

Ask a question
Results 901 - 950 of about 2,660
  • Solved
  • Reformatting a Date in Excel Solved/Closed

    Hello, I could really use your help with Excel. How can I change a date formatted like this...03/12/ just reflect the month and year...0...

    Bert | Excel | Latest reply: Bert May 8, 2015
    4 replies
  • get a percentage in microsoft excel Solved/Closed

    Hello, I am trying to get 10% of a number in another cell. rather than doing it in my head, I was hoping someone would know the formula. If you do,...

    theocupent | Excel | Latest reply: kb May 7, 2015
    3 replies
  • How to use name range..Please help to solve this issue.. Solved/Closed

    Hello, i have a excel work book which has few name ranges eg namerange1, namerange2, namerange3.. how i can display the resultant like if column e...

    mathewmunna | Excel | Latest reply: Mathewmunna May 7, 2015
    4 replies
  • Exam layout help Solved/Closed

    Hello, I want to display a classroom layout on sheet 2 using a list of names from sheet 1 I'm sure it's possible, I just don't know where to sta...

    Dibble | Excel | Latest reply: addseo1115 May 1, 2015
    8 replies
  • Conditional formatting cell if every cell contains "YES" Solved/Closed

    Hello, I want to A2 (surname) and B2 (forename) to turn green if every cell in range C1:F1 equals "yes". At the moment it is highlighting A2 & B2 i...

    LizzyDashwood | Excel | Latest reply: LizzyDashwood May 1, 2015
    2 replies
  • Compare 2 Sheets -> Summary differences Solved/Closed

    For an ongoing school project values of test subjects are changing over time. I would like to create a quick overview of these changes. Examples ...

    SidK | Excel | Latest reply: SidK Apr 30, 2015
    4 replies
  • Conditional Formatting for a particular column Solved/Closed

    Hello, I need to perform conditional formatting on a particular column, which should display the numbers entered into it, in 3 decimal format. ...

    Harish | Excel | Latest reply: Harish51290 Apr 30, 2015
    11 replies
  • copy & Paste based on specific condition Solved/Closed

    Please provide me the macro coding for the below scenario. I have four columns in my sheet 1 say Date,Name,Reference and Rate. When I am entering the...

  • How to search for a value in a range if found run a procedure. Solved/Closed

    Hello, I am trying to get my spread sheet to run a Macro I have that is working nicely (that copies the row and pastes it to another sheet in the ...

    Tiny | Excel | Latest reply: Tiny Apr 29, 2015
    4 replies
  • finding a date (N30) in a date range B5:B30 and returning A3text Solved/Closed

    Hello, Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula.... I have a column with different dates ...

    Kelley | Excel | Latest reply: MaxStart Apr 29, 2015
    3 replies
  • Auto. copy a row of data onto another sheet using conditions Solved/Closed

    Hello, I am new to VBA and I have two spreadsheets both in the same workbook. One sheet is full off information the other is a printable form t...

    DON'T KNOW | Excel | Latest reply: Don't Know Apr 28, 2015
    8 replies
  • Macro to Search for a word and put a code on the cell next to it Solved/Closed

    Hello, I'd like to scan a column for a certain word ("TOTAL LINE") and put a code (e.g "a") on the cell next to it each time it finds it.In case tha...

    A.E | Excel | Latest reply: A.E Apr 28, 2015
    2 replies
  • Can't open scanned document when broken up into 2 PDF's Solved/Closed

    When I scan a large color document on the color printer, the PDFs that are sent to me via Email can not be opened. The error message indicates it is n...

    shujaaishak | PDF | Latest reply: thierryhauet Apr 27, 2015
    1 reply
  • repair outlook express dbx file Solved/Closed

    has a sent items.dbx file which is about 400 over MB.. when open it, there is only a few emails with the file size quite small. any recommended free s...

    altairbishara | Outlook | Latest reply: ruudromein Apr 26, 2015
    2 replies
  • Macro for blanks Solved/Closed

    Hello, Would appreciate help! I have a spreadsheet which I run daily. The number of rows can change each time I run it (ie one day I have 5 rows; t...

    Connie | Excel | Latest reply: vcoolio Apr 21, 2015
    3 replies
  • sum if Solved/Closed

    Hello, Pls help me find the formula for below situation I am trying to sum up 4 when a cell in the Column A contains End with XX7. Otherwise it...

    senthil | Excel | Latest reply: senthil Apr 21, 2015
    0 replies
  • Date of birth in words Solved

    Hello, How can I enter date of birth in words in Excel?

    pinckroje | Excel | Latest reply: TrowaD Apr 20, 2015
    1 reply
  • recover corrupted outlook express folders Solved/Closed

    I accidentaly deleted some folders in my Inbox Folder. My problem is now, how do I get back the .dbx files without losing any important information? P...

    LambCastillo | Outlook | Latest reply: balighawad Apr 14, 2015
    1 reply
  • transfer data from one sheet to another automatically Solved/Closed

    Hello, I would like to populate data on a spreadsheet based on data obtained from another. Is this possible? If so, how can I do this? Example: S...

    myrna1310 | Excel | Latest reply: vcoolio Apr 14, 2015
    19 replies
  • What cell is my data coming from? Solved/Closed

    Oh dear - back again ... :^( After you guys help again with VBA. I'm never going to volunteer to try script-writing again! (at least not without...

    BrianGreen | Excel | Latest reply: BrianGreen Apr 8, 2015
    4 replies
  • Transferring information from previous spreadsheet Solved/Closed

    Hi everyone, I'm a junior doctor from Australia, and I'm trying to use excel to make my ward management a more efficient process! Everyday we get ...

    JoDWil | Excel | Latest reply: skreechy Apr 7, 2015
    17 replies
  • How do I resolve file corruption errors in powerpoint 2010? Solved/Closed

    Dear All, One of my colleagues is getting an error frequently(attached) in powerpoint 2010 and as a result he keeps losing many slides that he prep...

    manuelnoguera | PowerPoint | Latest reply: montesquinto Apr 6, 2015
    3 replies
  • Single Quote - Excel 2007 Solved/Closed

    Hi, Does anyone know what the single quotation mark ' means when entered at the beginning of a cell? I notice that the quotation mark does not ...

    smileanandh | Excel | Latest reply: FLAWLESSVW Apr 6, 2015
    8 replies
  • Conditional Formatting based on expiration dates Solved/Closed

    Hello, I am trying to figure out how to introduce conditional formatting to a range of cells with date values. I want each cell in the range to b...

    bc | Excel | Latest reply: BC Apr 6, 2015
    2 replies
  • Two criteria to check if a date in Excel Solved/Closed

    Despite my best efforts going round in circles on a simple problem. Help gratefully accepted.... If say, Cell A1 can have two values - "In" or "Out" ...

    LearningCurve | Excel | Latest reply: vcoolio Apr 5, 2015
    13 replies
  • Formula to add big number of day to date in excel sheet Solved/Closed

    Dear Please advise me how I can creat formula in excel sheet to help me to calculate due payment day for LC. As example I want to add 120 or 180 day...

    Renaming | Excel | Latest reply: mgkimmel Apr 4, 2015
    3 replies
  • Using the last few characters on a different sheet Solved/Closed

    Hi All, Me again - I HATE VBA! it is so simple that I get frutrated when I cant get a simple thing right. Im trying to write a VBA script that n...

    BrianGreen | Excel | Latest reply: BrianGreen Apr 3, 2015
    2 replies
  • VBA cod Solved/Closed

    how i send data to you for solve the vba cod create in my excel file.

    Prashantmh | Excel | Latest reply: Prashantmh Apr 2, 2015
    0 replies
  • vlookup won't work Solved/Closed

    I am trying to set up a formula in Excel 2013 that says to look at what is in X11, find the title and explanation in a group of cells on another works...

    Cookie5 | Excel | Latest reply: Cookie5 Apr 2, 2015
    2 replies
  • set cell value Solved/Closed

    Hello, how to create formula for: if AI=1, B1=2 than show C1= 25....... if A1=1 B1=3 than show C1=28........ if A1=5 B1=5 than show C!=32.... ...

    Jaspinder | Excel | Latest reply: MaxStart Mar 28, 2015
    1 reply
  • VBA Copy sheet to new Excel File + automated manual data entry Solved/Closed

    Configuration: Windows 7 / Firefox 35.0 Dears, I hope this is not a to extensive VBA script request and this is the place to ask. I need to cre...

    Sib | Excel | Latest reply: MaxStart Mar 28, 2015
    4 replies
  • excel formula Solved/Closed

    hello, hope you can help! working on an excel spreadsheet and require a formula: If cell a > 0 then cell b should equal the value in cell c thanks ...

    Nic | Excel | Latest reply: Nic Mar 27, 2015
    4 replies
  • Recover deleted emails in Outlook Express... Solved/Closed

    Hi! Prompt please... Is there any way to recover deleted e-mail messages in Outlook Express? An important message was accidentally deleted from the...

    joseph.robinson | Outlook | Latest reply: joseph.robinson Mar 26, 2015
    2 replies
  • Code Visual Basic Solved/Closed

    Hello, I've been unable to copy data from one sheet to another, based on selecting multiple criteria. I've been able to use the string below t...

    mcculloch1dj | Excel | Latest reply: mcculloch1dj Mar 26, 2015
    2 replies
  • Excell 2013 - conditional formatting using a formula- apply rule Solved/Closed

    Hello, I am trying to do the following : A1:A100 ==> dates B2:B100 ==> dates 1) apply conditional formatting to columns C1:BB1 if the containe...

  • Excel Formula Display in Cell Solved/Closed

    Hello, Apologize if the question is too stupid. In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to display the formula in cell A6 for this...

    eltonlaw | Excel | Latest reply: rc Mar 25, 2015
    6 replies
  • How to open a PRN file in Office/Word 2010 Solved/Closed

    Hello, How do you open a PRN file to see how it converted? I only want to open the document to see how it converted, not print it. I used Window...

    Janice | Word | Latest reply: Aduka Mar 25, 2015
    10 replies
  • Some cell Date Could not change Solved/Closed

    Hello, I was having the same problem and this solution worked But Some cell Date Could not change Configuration: Windows XP / Firefox 36.0

    Muhammad Afzal | Excel | Latest reply: TrowaD Mar 24, 2015
    1 reply
  • Comparing data in 3 columns on a Microsoft Excel spreadsheet Solved/Closed

    Would be really grateful for some help. I have 3 columns of different lengths with email addresses in them and I want to see all instances where th...

    daniz39 | Excel | Latest reply: daniz39 Mar 23, 2015
    2 replies
  • Excel 2013 Formula - maybe IF formula? Solved/Closed

    I have a list of names in Excel and I need to put their supervisor name in the cell to the right of each name. I would like to find a formula that wi...

    Cookie5 | Excel | Latest reply: Cookie5 Mar 23, 2015
    2 replies
  • WordNum help needed Solved/Closed

    Hello, I hope somebody can help. I use WordNum to spell the result of a formula and it gives me 4 digits (spelled) after the point. I need just ...

    april_tat | Excel | Latest reply: TrowaD Mar 19, 2015
    7 replies
  • Cell format Solved/Closed

    Hi Guys, I'm new here, I have a very limited knowledge about excel. My superior has asked me to do some sort of Advanced Cell Formatting in our per...

    mastachaah | Excel | Latest reply: MaxStart Mar 17, 2015
    3 replies
  • Text-to-text equals number Solved/Closed

    Hi.. I'm looking for a solution for a dilemma I'm in.. On sheet 1 I have a dropdown box in cell A1 and B1 is an emtpy cell. On sheet 2 I have the...

    kriswiberg | Excel | Latest reply: kriswiberg Mar 17, 2015
    5 replies
  • Formula, Blank Cell Solved/Closed

    Sorry in advance if this has been asked but I can't see anything. Excel 2010 I have a cell that will contain a date then the next adjacent cell the...

    Andyman123 | Excel | Latest reply: MaxStart Mar 17, 2015
    3 replies
  • convert date into words(english) in excel 2003, 2007 or 2010 Solved/Closed

    Hello i want to know how to convert date into words(english) in excel 2003, 2007 or 2010 for eg. 22.04.2010 - convert it into Twenty Second April T...

    manojfalak | Excel | Latest reply: MaxStart Mar 17, 2015
    1 reply
  • Conditional formating is applied based on date in two cells Solved/Closed

    Hi everyone I'm using Excel 2010 and applying conditional formating on dates in Column E. I don't want the formatting to be applied if there is the f...

    Capricorn56 | Excel | Latest reply: TrowaD Mar 16, 2015
    6 replies
  • Excel - Help Please! Drop Down and Data Filling Solved/Closed

    Good morning/afternoon. I was hoping you would be able to assist me with a query please. Currently my team is using 2 spreadsheets, one that li...

    CatherineGPR | Excel | Latest reply: CatherineGPR Mar 13, 2015
    4 replies
  • trying to have the current date go into one cell (A1) Solved/Closed

    Hello, I'm trying to have the current date go into one cell (A1) when an order number is entered in another cell (A2) but don't want the date to aut...

    dbmich | Excel | Latest reply: dbmich Mar 12, 2015
    3 replies
  • A strange Range question ... Solved/Closed

    Hi guys Im back with a new twist on one of my old problems. I had help earlier and one of you kind people hellped me out with a solution (thanks ag...

    BrianGreen | Excel | Latest reply: BrianGreen Mar 11, 2015
    8 replies
  • adding a loop to macro to insert pictures Solved/Closed

    Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...

    vba | Excel | Latest reply: M_TheJax Mar 5, 2015
    7 replies