Office Software Forum - solved topics
- Excel (9,800)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
- Solved
-
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 ...
-
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...
-
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" ...
-
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...
-
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...
-
VBA cod Solved/Closed
how i send data to you for solve the vba cod create in my excel file.
-
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...
-
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.... ...
-
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...
-
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 ...
-
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...
-
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...
-
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...
-
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...
-
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
-
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...
-
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...
-
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 ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Change calculated to a hard date Solved/Closed
I used a +1 formula to create dates in column A. Now I want to make these "hard" dates so they don't keep changing every time I add a row. Thank you...
-
recovering missing emails by restoring outlook identity from tim Solved/Closed
had a problem with Outlook 2011 client - emails went missing and not in deleted / purged folders if i restore outlook identity from a date i know h...
-
Problem recovering deleted item in Outlook 2010 Solved/Closed
I try to open deleted item recovery in Outlook 2010 and attempts to recover any message and receives the following error message: "Outlook was unable ...
-
Opening ost files with Outlook 2013 Solved/Closed
How can one open existing ost files in Outlook 2013? I tried but I get a message that it is not an Outlook Data file.
-
WINXP OUTLOOK EXPRESS LOST INBOX Solved/Closed
I STILL HAVE ALL MY SENT ITEMS BUT ONLY SOME ITEMS FROM 2006 LEFT IN MY INBOX' PLEASE HELP.
-
Transferring numbers to new worksheet automatically Solved/Closed
Hello, I'm making a spreadsheet showing weekly costs. I've set it up so that each worksheet is a week, with totals using =SUM. I want to transfer th...
-
Macro to create tabs and populate from other worksheets Solved/Closed
I already posted this on the programming forum but have not had any responses as yet so I am trying here as it may be more appropriate. Current Set...
-
How to transfer lines of txt from one sheet to another sheet? Solved/Closed
Hello, I have an excel file that has 2 sheets of relevant information that I need excel to logically determine line up and from there automaticly ...
-
Computer show me the error message. (.pst file) Solved/Closed
Hello, After restore the .pst file back to hard disk, the computer show me the error message. How can i repair this file? Please help Best regards....
-
How to restore the telephone book from the wab file? Solved/Closed
How to restore the telephone book from the wab file? There is a file .wab, by the file size can be seen that the contacts are there but when opening ...
-
Outlook Express 6.0 Losing Contacts/error msgs. opening and send Solved/Closed
During the last six weeks or so, whenever I install "updates" for my computer (Windows XP), my Outlook Express loses all my contacts, as well as becom...
-
Repair Excel Files. Solved/Closed
Hello Experts, My problem is as follow: We're reinstall an Laptop With Windows 7, but the user does not back up a folder, This folder contained ...
-
how to remove image with VB? Solved/Closed
Hello, I have everything working but removing the image before saving. The code is not working and not even sure where to place it. (using excel...
-
Conditional formatting based on another cell; apply to rows Solved/Closed
Hello, I have two columns. Column A is for expiration dates, and Column B has a drop down menu indicating the status of an request (eg, pending, a...
-
Need help with date and if statement newbie Solved/Closed
Hello, I am trying to work out a formula if possible, to determine a date based on a date in another cell. So if the Date in Cell A is 3/1/2015,...
-
Convert Date into English Words in Excel Solved/Closed
Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 or ...
-
How to replace * with / in all formulas in an excel sheet Solved/Closed
hi Guys, does anyone of you know please how to replace the multiply sign with a divide sign in all of the formulas in an excel sheet? I could not f...
-
time calculation (TimeXnumber) Solved/Closed
Hello, i want calculate the salary of workers like the following example. worker No.1 salary/hour 1$ working hours this week 3:45 (3 hou...
-
Even page numbers missing Solved/Closed
Can anyone help Header and page numbers missing on even pages!
-
Conditional formatting with range Solved/Closed
Hello, I have a little bit of a problem, I want to mark a cell in a range that is equal to another cell in different range, I can't figure it out....
-
IF/OR Formula Solved/Closed
Help please I need to look up a cell and if it =1 return 1, =2 return 0.6, =3 return 0.4, = 4 return 0.2, if >4 return 0.0 for example A B ...
-
How to repeat a row 4 times, while increasing sequence Solved/Closed
Hello all, I need help on the best way to repeat this 4 times, and then increase the number at the end. I need this: Column A AAA_BBB_0002135 ...
