Office Software Forum

Ask a question
Search
Close
Results 6051 - 6100 of about 16,700
  • How to define specific format for number? Solved/Closed

    Hi, I would like to define specific format in excel. For example, if I type 123456789 and hit Enter, it should be 123-456-789 or 123-45-6789 autom...

    ugn10 | Excel | Latest reply: ugn10 Mar 4, 2014
    5 replies
  • add days to Date Solved/Closed

    Hello, I need a formula that help me to add days to Date and it gives me the result in date format For example 03/01/2010 + 25 = 28/01/2010 Th...

  • Macro won't paste in second sheet "Run-time error:9" Out ofRange Closed

    I am trying to copy from sheet 1 and paste in sheet 2. Checking row "G" for the letter "x", the "x" marks the rows I would like to copy from sheet1...

    Huffman09 | Excel | Latest reply: venkat1926 Mar 3, 2014
    1 reply
  • If statement using date to change row colour Solved/Closed

    I have a sheet with the following header row: Reference Client MAWB / BoL Date logged Date completed Days to resolve Logged by Caller type Error ar...

    Z Kindo | Excel | Latest reply: Z Kindo Mar 3, 2014
    2 replies
  • Excel 2010-VB Macro formula into many spreadsheets Solved/Closed

    Hello Everyone, I am new in VB programming and I am trying to write a macro in Excel. Basically, I have written a formula in Excel which enable me ...

    AnFey | Excel | Latest reply: AnFey Mar 3, 2014
    4 replies
  • can not send email or messages Closed

    good morning I keep getting a message "can not send message from my gmail, outlook and yahoo accounts". please help. Configuration: Windows / ...

    abj | Outlook | Latest reply: abj Mar 2, 2014
    0 replies
  • automate the sheet in order to calculate costs Closed

    I have an order sheet and 3 reference sheets. I would like to automate the sheet in order to calculate costs and for selling different types of produ...

    Soj17 | Excel | Latest reply: Mazzaropi Mar 1, 2014
    1 reply
  • IF function using dates Solved/Closed

    Hi I am trying to write an IF function for an escalation calculation and need some help please. What I want to achieve is to have a date filled ...

    Escalation | Excel | Latest reply: Escalation Feb 28, 2014
    2 replies
  • IF function using Dates Closed

    Hi I am trying to write an IF function for an escalation calculation. What I want is to have a date filled into cell B13 (22 February 2014). The I...

    Escalation | Excel | Latest reply: Ambucias Feb 28, 2014
    1 reply
  • Data comparison Closed

    I have a database compiled in my office of current students in a college program for a particular semester AND a database from administration with the...

    Foresterdon | Excel | Latest reply: Ambucias Feb 27, 2014
    2 replies
  • Macro Syntax Error Closed

    HELLO THERE NEED HELP TO RESOLVE AND MAKE THE BELOW CODE WORK IN EXCEL(MACRO) ActiveCell.FormulaR1C1 = _ "=IF(RC[-2]=""10X"",""Acquisition on do...

    luqman | Excel | Latest reply: ac3mark Feb 26, 2014
    1 reply
  • Change the column Closed

    Hello, I have to do the same thing as you but instead of using the column B, I have to use the column A. I tried to change your code but I didn't...

    Syline | Excel | Latest reply: ac3mark Feb 26, 2014
    3 replies
  • Excel cmd button to transfer data from source to another. Closed

    Hello, Can someone help me with my problem. Is there a way to create button to transfer data from source sheets to any other sheets in the same wo...

    MC JONES | Excel | Latest reply: ac3mark Feb 26, 2014
    1 reply
  • how do i change the result of a formula to normal text or values Solved/Closed

    Hello , i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that for...

    kelnasawa | Excel | Latest reply: kelnasawa Feb 26, 2014
    8 replies
  • IF Formulas with Dates Closed

    Hi all, I have a large spreadsheet that contains revenue information tied to sales deals. Column A contains the expected deal closing date and c...

    orodriguezjr | Excel | Latest reply: orodriguezjr Feb 25, 2014
    2 replies
  • data sorting Closed

    Hi Folks, I need your help in data sorting. Basically I just want to automate the data to be sorted to another table, Names from table1 to table...

    Jearnizck | Excel | Latest reply: TrowaD Feb 25, 2014
    2 replies
  • Excel MMYY format in order Solved/Closed

    Hello, I have a data set and a column currently with a selection of dates in MYY and MMYY, eg. 909 (Sep 2009) 1011 (Oct 2011) 1212 (Dec 2012...

    nickkyh | Excel | Latest reply: nickkyh Feb 24, 2014
    5 replies
  • Macro adding a row and numbering it in Excel Closed

    Hi, Please could someone help I am trying to record a macro that will add a row below and number A2 with a number say 1, 2, 3 etc. I also need to...

    scully693 | Excel | Latest reply: venkat1926 Feb 21, 2014
    1 reply
  • Date format Closed

    Hi, can i have solution for this question how to change date format this case to 21/11/13 to this 21-Nov-13. Thank you............

    Ranjithv | Excel | Latest reply: Kevin@Radstock Feb 20, 2014
    4 replies
  • Macro Closed

    Hi, I want to setup a Macro to cary these 2 rows and coloms when I hit the Macro button in excel. Can any one help me. I am staeting with E7:F7. T...

    sjcland | Excel | Latest reply: sjcland Feb 20, 2014
    2 replies
  • Office 365 activation key ? Closed

    How & where to get office 365 activation key? I am unable to use it now its been six months i started using Office 365 but suddenly it sopped working....

    silhouttejames | Office Software | Latest reply: Ambucias Feb 19, 2014
    9 replies
  • Excel formula help Solved/Closed

    Hello, I would like to request some assistance with a formula I have been trying to figure out. I know it's a simple one, but it evades my mind. ...

    jgates | Excel | Latest reply: ac3mark Feb 19, 2014
    5 replies
  • Apply conditional formatting rule if value is true? Closed

    Hello all! I have been searching for this answer for many days now, and I am getting quite frustrated. I'm not sure if it will work or not, but here i...

    apierson0 | Excel | Latest reply: apierson0 Feb 19, 2014
    2 replies
  • inserting photos or image into a PDF Closed

    I have PDF complete office edition 4 and I am trying to update a flyer that we created a few years ago but the program wont let me change or insert a ...

    jcomp1972 | PDF | Latest reply: ac3mark Feb 19, 2014
    1 reply
  • Track Office Log IN and Log out timings Closed

    Hi Team, Thanks for providing me an opportunity to be a part of the wonderful Team. I would need a Macro to track the shift timings of the emplo...

    sygururaj | Excel | Latest reply: ac3mark Feb 19, 2014
    6 replies
  • how do i change the result of a formula into normal text ? Closed

    Hello , i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that f...

    kelnasawa | Excel | Latest reply: kelnasawa Feb 18, 2014
    0 replies
  • if cost is 18.66 what would be 0.6% of it (calculation method) Solved/Closed

    and if basic pay 65000rs what would be the 2.5% of it(calculation method)

    nooblord | Excel | Latest reply: nooblord Feb 17, 2014
    5 replies
  • Copy Data from one sheet and putting it below a particular Cell Closed

    I have a excel with 3 sheets . My requirement is to pull data from sheet1 ,sheet2 and put it into sheet3. There would be two headings in sheet 3 1...

    ajita | Excel | Latest reply: TrowaD Feb 17, 2014
    1 reply
  • Moving Information from 1 set to another based on an IF Closed

    I have two worksheets. 1 is Proposals 2 is Projects When a row in Proposals is given a Project #(a cell in that row) I need the cells in that row to ...

    JDI12 | Excel | Latest reply: TrowaD Feb 17, 2014
    1 reply
  • How to move data from one sheet to another Closed

    I have an excel spreadsheet, and I need a macro , in sheet1 I have several values of 7 numbers in a cell, example 1|2|3|4|5|6|7| up to 93|94|95|96|97|...

    maximbebi | Excel | Latest reply: TrowaD Feb 17, 2014
    1 reply
  • how to formula the table Closed

    Table 0 to 1000 value is 2 1001 to 2000 value is 3 2001 to 3000 value is 4 3001 to 4000 value is 5 4001 to 5000 value i...

    ernanivalmon... | Excel | Latest reply: BunoCS Feb 17, 2014
    1 reply
  • Conditional Formatting with dates Closed

    Hello, Your help would be greatly appreciated I have a cell with a date in it (A1). I want that cell to change colour if the following criteria is ...

    scarey3 | Excel | Latest reply: venkat1926 Feb 16, 2014
    1 reply
  • Date issues Closed

    Hello, i have the following problem with excel 2010 on windows 7 pro. i select col A and format it to Date yyyy-MM-dd i enter 2014-01-08 in A...

    DemetriRsa | Excel | Latest reply: ac3mark Feb 16, 2014
    7 replies
  • Data import from a Notepad Closed

    Hello everybody. Hope you are doing well. please help me in the following situation. Suppose i have a notepad file where there are some company rec...

    mahfuz19 | Excel | Latest reply: ac3mark Feb 16, 2014
    1 reply
  • how to convert Arabic Pdf file into Arabic word Closed

    Hi all of you I would like to help me which software to convert Arabic pdf into Arabic word and you know most software convert pdf file into word do...

    jaamacilmi | PDF | Latest reply: Ambucias Feb 15, 2014
    1 reply
  • need macro help Closed

    Hello; thanks for viewing this question.... I need help creating a macro, with detailed instructions on how to put it into excel and actually make ...

    bbrown123 | Excel | Latest reply: venkat1926 Feb 14, 2014
    3 replies
  • microsoft office 7 Closed

    how i will download free Microsoft office.

  • formulas Solved/Closed

    sum a column if two other columns contain a specific text each so sum (if (A1:A20=1 and B1:B20 = "A", C1:c20)

    Gmooney | Excel | Latest reply: Gmooney Feb 14, 2014
    2 replies
  • add video in windows 7 ms office powerpoint? Closed

    how to add video in windows 7 ms office powerpoint?

    sejal khunt | PowerPoint | Latest reply: ac3mark Feb 14, 2014
    1 reply
  • for need a help. Closed

    can't support file format of office software.

    Temjen Aier | Open Office | Latest reply: ac3mark Feb 14, 2014
    1 reply
  • Copy data from current work to another Solved/Closed

    Hi All, Please can you help me with the VBA code which copies columns from current active workbook to another closed workbook at the end of rows.....

    Sushil Gaikwad | Excel | Latest reply: Sush Feb 14, 2014
    2 replies
  • Excel column linking query Closed

    Hi, I would like to know how to link one column with another therefore having the second column recognise it at the same. eg Typing a name in colu...

    hollie2014 | Excel | Latest reply: venkat1926 Feb 13, 2014
    1 reply
  • Excel 2007 - Conditional Format Using Calendar Months Closed

    I'm have a workbsheet that has a bunch of dates that show when people have completed their annual training. What I'm trying to do is take the train...

    Boondagger | Excel | Latest reply: ac3mark Feb 13, 2014
    1 reply
  • software Closed

    hi may i get a free version of google earth

    kiggundu frank | Office Software | Latest reply: ac3mark Feb 13, 2014
    1 reply
  • Conditional formatting from another cell by range Solved/Closed

    Hey, I need helpppppppp i want to change the color of a cell based on the range value of another cell eg. i need a1 to be red if b1 is < 70%, Y...

    riboss | Excel | Latest reply: ac3mark Feb 13, 2014
    1 reply
  • put the value from various excel sheets using lookup : Closed

    In Sheet1, A B C D ...

    SUMAN4KGP | Excel | Latest reply: SUMAN4KGP Feb 13, 2014
    0 replies
  • Watermark on selected pages but no changes to header Closed

    Hello, I have a document that contains a header (the same for all pages but the first one) Now I need to add watermark but only to selected page...

    beru279 | Word | Latest reply: beru279 Feb 11, 2014
    0 replies
  • #value Closed

    Hi, am trying to correct a formula. Each time am using this formula: =IFERROR(VLOOKUP(B15;'Liste des Prix Net'!$A$1:$B$8;2;0);(P15/Q15)*(L15/1000)...

    boule11 | Excel | Latest reply: TrowaD Feb 11, 2014
    4 replies
  • Auto sheets .... with common data? Closed

    Hello, I would like to have a new sheet generated on open of workbook with sheet name generated in sequence (i.e. main sheet has common data the...

    diribarren | Excel | Latest reply: TrowaD Feb 11, 2014
    3 replies
  • Macro to move mail from inbox to folder Closed

    Hello, I am looking for a macro that will move an email item from the inbox of a mail account to a folder in that mail account's inbox. The tri...

    TomTom111 | Outlook | Latest reply: TrowaD Feb 11, 2014
    1 reply