The discussions

Need help with date and if statement newbie

 Solved

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,...

5 replies Last reply on 20 Feb 2015 by
cmarzahn

If function help

Hello, I am working on a spread sheet whereby one cell contacts REV and RP and I then want the amount linked to that row to become a negative figure...

1 reply Last reply on 20 Feb 2015 by
cmarzahn

Numeric value to word.

How I can create any amount in word format from numeric format automatically or using the formula function in MS Excel Sheet? Kindly showing easy ...

1 reply Last reply on 20 Feb 2015 by
cmarzahn

How to interchange the date format

Hello, I have my date format as 01.02.2015 but when we replace the . with / it shows as 01/02/2015 which is 02-Jan-2015. I want to show it as 01-F...

1 reply Last reply on 20 Feb 2015 by
cmarzahn

If cell ="text" =other text

Hello, I'm looking for a formula that will help me do the following: If cell contains "Other (please specify)" that value of that cell needs to...

1 reply Last reply on 20 Feb 2015 by
cmarzahn

Office-word is messing up, or...?

For the last five months as I type a document, random letters are appearing in the words. These are not self-made typos, (I thought it at first) they ...

3 replies Last reply on 20 Feb 2015 by
Ambucias

Data is not appear in drop dawn list in filter

Hello, i have some data rows almost 2000 there is black rows between every row. filter did not showing whole data in drop dawn so i can remove empty...

1 reply Last reply on 19 Feb 2015 by
vcoolio

Excel tutor

Hi forum I am new here and I need excel tutorial, can anyone help?

3 replies Last reply on 19 Feb 2015 by
Ambucias

The date that i enter the data

Hello, is that possible to know the date that i enter the data in a cell. for example i enter the data in cell B1 today and i want this date in C1 ...

3 replies Last reply on 19 Feb 2015 by
RayH

Generating new document

Hello, I have an internal budget and I would like to use macro to generate another workbook with specific information from that budget with formul...

1 reply Last reply on 19 Feb 2015 by
cmarzahn

If formula to identify data outside a timeframe

Hello, I have a excel report that contains data including a date created and inception date. I would like to run a formula that will tell me if the ...

1 reply Last reply on 19 Feb 2015 by
vcoolio

Shortcut/keys in excel

Hi! I'm Jen..I know how to use the Excel, however, I haven't use it for years now and my Job now is Secretary so I will be encountering Excel, Word, P...

2 replies Last reply on 18 Feb 2015 by
ArashMan

Convert date into english words in excel

 Solved

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 ...

3 replies Last reply on 18 Feb 2015 by
amol

Date to words

Hello, sir please tell me in detail steps of converting date to words

1 reply Last reply on 18 Feb 2015 by
Computertech

How to replace * with / in all formulas in an excel sheet

 Solved

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...

4 replies Last reply on 18 Feb 2015 by
DG83

Time calculation (timexnumber)

 Solved

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...

4 replies Last reply on 17 Feb 2015 by
ArashMan

Search similar entries

Hi, I need to know, how to search similar entries in list of numeric entries. eg: Suppose I have numeric entries of 6 digits each having number...

1 reply Last reply on 17 Feb 2015 by
TrowaD

Ms word is not working please help me

Ms Word Is Not Working Its Showing windows connot access the specified device, path. or file. you may not have the appropriate permission to access th...

12 replies Last reply on 17 Feb 2015 by
Bosvaibhav

Count a value change in cells

Hi, I'm trying to count how many times did 1 cell from a row has been changed from 1 to 0 and then back to 1, how many times did this form of change h...

2 replies Last reply on 16 Feb 2015 by
MindTwister

Conditional formatting based of another cell

Hello, I am attempting to do conditional formatting in Excel 2013. I am trying to make Cell C 3 turn red if cell 1 is 25% less or greater than cell...

1 reply Last reply on 16 Feb 2015 by
TrowaD

How to create a file in makro and copy a row from other makro

Hello, Please help me how to create a new excel file and copy data into this from other excel file. The new file filename will be a column.xls from ...

3 replies Last reply on 16 Feb 2015 by
TrowaD

Even page numbers missing

 Solved

Can anyone help Header and page numbers missing on even pages!

2 replies Last reply on 16 Feb 2015 by
drumgora

Transferring data from one spreadsheet to another

Suppose i have a file name tan.xls and another file names rule.xls! then i want to copy all data in tan.xls file in cell D2 - D22 to rule.xls file in ...

1 reply Last reply on 16 Feb 2015 by
Computertech

Conditional formatting help please

I need some help that could possibly save me a huge amount of time. I'm new to conditional formatting and am working on a new method to help my staff...

1 reply Last reply on 14 Feb 2015 by
vcoolio

Trfing data from master wks to another wks

Hi all...I would to get help from here as I trying to input my project data into my Master list. When we select won or lost under the status for proje...

14 replies Last reply on 14 Feb 2015 by
vcoolio

Populating a work sheet from excel based

Hello, I need your guidance please: I've got a tall order :) I hope you can help me! I am trying to have a new worksheet created from a templa...

3 replies Last reply on 12 Feb 2015 by
TrowaD

Insert images in cells

Hello, Would anybody know how to change this macro https://ccm.net/faq/14170-excel-a-macro-to-insert-pictures-in-a-worksheet so that images are in...

1 reply Last reply on 11 Feb 2015 by
ac3mark

Can't open a pdf from email

Hello, I am currently running Windows 8.1 I have Microsoft Office loaded on my laptop I have also purchased and have installed Adobe Acrobat Pro...

1 reply Last reply on 10 Feb 2015 by
Computertech

Conditional formatting with range

 Solved

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....

2 replies Last reply on 10 Feb 2015 by
MindTwister

Dell latitude d800 admin password

Thank You

2 replies Last reply on 10 Feb 2015 by
akoh.john

If/or formula

 Solved

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 ...

3 replies Last reply on 10 Feb 2015 by
vcoolio

Copy data from main sheet to another sheet

Hello, I have a document that has a quote on the first sheet. What I want to do is if the code in column C meets a certain criteria, it will auto...

1 reply Last reply on 10 Feb 2015 by
venkat1926

Display value in a cell a7 which is refered to the value in a6

Hello, I want to display value in a cell A7 which is refered to the value in A6 which shows the average of A1:A5 and the value of A6 satisfies the...

1 reply Last reply on 9 Feb 2015 by
TrowaD

Script

Hi Joe here, Sheet 1 Data A B 1001 HE 1002 SHE 1003 HIS 1004 HERS When I type t...

1 reply Last reply on 9 Feb 2015 by
TrowaD

How to save a data excel to non data spreadsheets to excel

Hello, I have a question? How to save a data excel to non data spreadsheets to excel Configuration: iPad / Safari 8.0

1 reply Last reply on 9 Feb 2015 by
RayH

Excel, changed format tue, 11 nov 2014 08:14:09" to dd/mm/yyyy

Hello, I'm looking to convert the following excel format of "Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy. Thanks in advance for your answers. j...

1 reply Last reply on 9 Feb 2015 by
venkat1926

Identify same values in column a

Hello, I have an excel sheet with too many rows. But in Column A, I have many values which starts with XYZ. I have to identify them and need to use...

1 reply Last reply on 9 Feb 2015 by
venkat1926

Inserting different photos into cells- macro

Hi, I am not a super savvy programmer, but looking for a Macro that might automate inserting a photo (so user selects image) and then re-sizing the ph...

1 reply Last reply on 8 Feb 2015 by
RayH

How we can convert number to word in excel

how we can convert number to word in excel?

1 reply Last reply on 7 Feb 2015 by
RayH

Need to create a macro

i have no clue on how to create a macro.i need to copy all items in sheet 1 rows to columns in sheet 2 every time its updated. sheet one will change ...

2 replies Last reply on 6 Feb 2015 by
vcoolio

Shape not showing text in excel

I moke a shape in excel I wrote text in shape but when I click on another cell the text disappears. Please Help!

1 reply Last reply on 6 Feb 2015 by
RayH

Retrival of email login data

 Closed

Hi guys - I wonder if you could help with a friends problem? He was using Windows XP and Outlook Express to access his emails. Then tragedy struck...

Last reply on 6 Feb 2015 by
Ambucias

Macro for opening a new word document from my templates item

Hello, I am using Mac Office 2011. I regularly need to create new Word documents, using a customized template I created. Usually, I have to go...

1 reply Last reply on 6 Feb 2015 by
Computertech

If function

Hello, I'm having a bit of a trouble working the If Function in excel. Here's my problem: My manager asked me to find the commission fees to cha...

1 reply Last reply on 6 Feb 2015 by
vcoolio

Number that turns in to date.

Hello, hi I'm Nokuthula. I want to ask why when I try to put a number it turn and become a date. Why is that ? Configuration: Windows 7 / C...

1 reply Last reply on 6 Feb 2015 by
vcoolio

How to repeat a row 4 times, while increasing sequence

 Solved

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 ...

2 replies Last reply on 6 Feb 2015 by
OldCoder

Using one cell to refer to many

Hello, I'm trying to do something I'm not sure is possible. I have a spreadsheet to keep track of receipts and group items by category. In one column ...

2 replies Last reply on 5 Feb 2015 by
Underwater

Creating a task reminder for all tasks for that day

I'm hoping someone will be able to help me. I need to attempt to create a task reminder pop up that will list all tasks that need to be done today. An...

4 replies Last reply on 5 Feb 2015 by
mhurd

Converting rows of data in notepad to columns

 Solved

Hello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains firs...

2 replies Last reply on 5 Feb 2015 by
Philgood_FR

Excel

Hello, How to copy data from one sheet in a row containing formulas to another sheet in a column but not in a row still have the same data with it...

1 reply Last reply on 5 Feb 2015 by
TrowaD
Results 3301 - 3350 out of a total of 12,264