Forum
Office Software
- Popular discussions
-
If cell = date return yes or no. [Solved/Closed]
Hello, I need an excel formula that tells me if a a cell = a date to return yes or no. I tried =IF(I12=TRUE, Yes, No) and =IF(I12=DATE, Yes,...
-
Removing " false" value in "IF" [Solved/Closed]
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an...
-
How to calculate positions(1st,2nd,3rd...) in Excel [Solved/Closed]
Hello, hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my...
-
Date formatting in dd/mm/yyyy [Solved/Closed]
Hello, I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we...
-
Convert number to spelling [Solved/Closed]
Hello, I Can change the Number into Spell but the problem is it does not convert in Indian Rupees. Present Situation =SpellNumber(58.20) =...
-
Inserting an image without the white background [Solved/Closed]
Hello, I have an image that I have vectorized... or so I think I have.... and I when I try to insert it into a document this white square...
-
Percentage calculation [Closed]
Hello, How to know the percentage. Example total bill amount is Rs. 25000 and we are paying Rs.18000. Can u please help me find how to get the...
-
if date in cell is greater than date in cell [Solved/Closed]
Hello, I am a beginner with formulas in Excel. I am working with dates formatted dd/mm/yyyy. I need a formula that will return a value of yes...
-
Spell number in India Rupee [Closed]
Hello, I want spell number in India rupee. System Configuration: Configuration: Windows 7 / Mozilla 11.0
-
Restart Microsoft Office [Closed]
I have this MS Office Professional Plus 2010 and it needs activation key. I entered the activation key and it said the picture here. I don't...
-
SKU011.CAB [Solved/Closed]
when I go to open ms word or ms excel computer ask for sku011.cab file. I have no cd of office 2003. please help
-
Select the cell that a button is in [Solved/Closed]
Hello, I want to run a macro using a button in Excel 2010 without regard as to the location of the current cell. In other words, when I...
-
Letter received and dispatch system [Closed]
i have to convert the manual system of letters received and dispatch records to computer system.The table structures are given below Receiving...
-
Nested IF functions using time values [Solved/Closed]
Hello, can someone tell why this wont work. The time value functions work separately on their own, and I followed the excel help for nested if...
-
how to open my corrupted rtf document [Solved/Closed]
Hello, Can anyone please investigate me how to open my corrupted rtf document? When I try to open it I am getting: Loading error Any...
-
Inserting day of week along with date [Solved/Closed]
Hello, I am currently working on a spreadsheet and trying to set the cell format so that it displays the day of te week alongside the date eg...
-
Copy formulas across workbook [Solved/Closed]
Hello, I want to copy Excel 2007 formulas from one workbook and past to the other workbook without the workbook name in the pasted formulas. ...
-
Changing a cell value based on the color of a [Solved/Closed]
Hello, Is it possible to populate a cell in Excel 2003 with a number value that is based on the color of an adjecent cell? ie A2 = 0 if B1...
-
How to Move the ActiveCell to the next row [Closed]
Hello, Move the ActiveCell to the next row is simple: ActiveCell.Offset(1,0).Select Ok. But if AutoFilter is on, that command can lead me to a...
-
not able to cut or copy attachment file [Solved/Closed]
Hello, I am not able to cut or copy any attachment file in outlook 2003.In a new message,i attached a file(pdf,xl,doc etc) i want to copy...
-
Microsoft Office 2010 product key [Solved/Closed]
Hi, How can I get the product key for Microsoft Office 2010 so I can complete downloading it?
-
Can't open my 2007 document [Solved/Closed]
Hello, i can't open my docx word document.i'm running office 2007 and i'm clickin all my word documents and getting the same response "the file...
-
file conversion message [Solved/Closed]
Hello, I use Microsoft Outlook 2003 for my emails. I cannot open any attachment that comes as a Microsoft Word document. I get the message "File...
-
How to drag a formula without changing color. [Closed]
Hello, I have a spread sheet with different colored rows. I want to drag a formula down a column with about 500 cells through the alternating...
-
Ms Access ranking students [Closed]
Dear All, How can i rank my student in ms access to find thier rank using vb, macro, query, expression builder or code builder which one the easy...
-
convert value in the cell into integer [Closed]
Hello, I am working on creating a macro. I want to go through the sheet and take the quantity that enter in the cell and copy and insert the...
-
VLOOKUP column number searching. [Solved/Closed]
Dear All, I'm currently using a VLOOKUP to populate an information table im creating however im still adding columns to the sheet which holds...
-
illustrator File Damaged And Could Not Be Repaired [Solved/Closed]
its been coming more and more common for my files to become damaged and not be able to open for me. It started with files that had an insane...
-
auto incrementing alphanumeric cell by 1 [Solved/Closed]
Hello, I have an alpha numeric cell in excel sheet. for example IND/APR/6734/INV I am using it to give number to the invoce that I generate...
-
Need help to remove FALSE from cell [Solved/Closed]
Hello, Anyone please. How remove FALSE from a cell Here below is my formula. =IF(ISNUMBER(G17);IF((G17-$I$10)
-
Copy row and insert n times [Solved/Closed]
Hello, I have an example below, I'd like to take the first row, copy it "n" number of times, then take the next row copy it the same "n" number...
-
Conditional formatting of entire column [Solved/Closed]
Hello, I have two columns in excel 2010 which are generated by sensors measuring the same thing. In theory the 2 columns should be the...
-
Why does printing change font of document [Closed]
Hello, When I go to print a document off of either desktop laser printer or more industrial (big printer/copier/scanner/fax that is in a room...
-
Conditional hide column [Solved/Closed]
Hello, I need someone to help me please. I want a VBA code in excel that will look to a value in specific cell (i.e: A1) in one sheet only...
-
How to create serial numbers [Solved/Closed]
Hello, I have an excel format shows different values of schedule of correspondence and some of the mails are gone to different addresses and...
-
Formula to copy data from one cell [Closed]
Hello, I need a formula to Copy data from one spreadsheet to another automatically. I need it to update the most recent figure into it and copy...
-
microsoft publisher - product key [Closed]
Hi I just downloaded Microsoft Publisher and now I need the Product Key to open it. What do I do?
-
Office 2008 [Solved/Closed]
Hello, I installed Office 2008 for Mac. I needed to uninistall it and re-install under a different product key. The computer remembers...
-
Copy row if a range of column matches a value [Solved/Closed]
Could you please help me with the following macro. The following macro basically copies the entire row if the column B contains the value "1"....
-
Issue with Selection.End(xlDown) [Closed]
Hello, I am working on a few macros and came across this problem. If I use the code below to select a range of cells and if my working rows...
-
Copy Rows from one sheet to others based on a condition [Solved/Closed]
Hello, I have a workbook for our teams budget that has 1 master sheet with 28 columns. The master sheet will be updated with more rows often...
-
Convert the fraction to Month and Year [Closed]
Hello, I need to convert 05/10 to Month and then Year. i.e., for Example it should come as May 2010. Please give an idea to get the...
-
Stop #N/A appearing after a vlookup [Solved/Closed]
Hello, I need to stop #N/A appearing after doing vlookup. I Understand that this happens because it refers to no value. Anyway I can make...
-
Leave Value unchanged if false [Closed]
Hello, Vlookup posts a value to worksheet1/C3 when the trigger is the date. C4thruC20 are "0". When the vlookup trigger is changed to the next...
-
Enter current time in a cell by clicking it [Solved/Closed]
Hello, I'm trying to minimize the effort to input data in a sheet I've built for recording time for dispatched workers I need to find a way to...
-
Microsoft Office Adding Publisher [Closed]
I purchased the 365 days of Microsoft Office along with my new computer in December and it didn't include Publisher. How can I add that?
-
Clear cell contents based on color [Solved/Closed]
Hello, I have a range of cells (E7:AI18) which I want to delete the contents of, if the color is white, gray-25% or gray-80%. So if cell E7...
-
How do i change date format in (dd.mm.yyyy) [Solved/Closed]
Hello, How do I change the date format from (dd/mm/yyyy) format to (dd.mm.yyyy) format? And how can I get today's date in dot format...
-
conditional formatting based on month as text [Closed]
Hi, I have a list of months in one column, and I want to format it so that if it is the current month, the cell is red; if the month is one...
-
my tally is not opened [Solved/Closed]
Hello, click the tally icon it shows problem with shortcut, the item tally9.exe that this shortcut refers to has been changed or moved, so...
-
Google Play Store (APK)
-
Minecraft
-
xVideoServiceThief
-
TubeMate YouTube Downloader for Android
-
Instagram for PC
-
Microsoft Office 2010
-
Truecaller: Caller ID & Dialer for Android
-
Adobe Flash Player
-
Facebook Lite for Android
-
YouTube Downloader HD