General

Macro button gets bigger when clicked
What makes a macro button or its text get bigger when clicked? ... 27 May 2010 17:04

Excel tol .dat file
ActiveWorkbook.SaveAs Filename:="C:\Filename.dat"_ , FileFormat:=xlText, CreateBackup:=False "Mia" wrote: Hello, I have a problem. I need to create a dat-file from a excel-file. Do anyone know howe to do this I'll be wery grateful! -- Best regards Mia ... 27 May 2010 17:04

Need help for multiple entries
Hi I want to be able to put say the letter A in column A-1 but want a formula that wil also put the same letter A in like 6 more times for instance B-2, C-3, D-4, E-5,F-6,G-7. All with just the one entry in A-1. Thanks Karl ... 27 May 2010 17:04

Find
Thanks for getting back so soon, however I don't want to replace the dash, I want to delete any rows where the 3rd character = "-" -- Randy "Jacob Skaria" wrote: Try SUBSTITUTE() with the text in cell A1 =SUBSTITUTE(A1,"-",,1) -- Jacob (MVP - Excel) "Randy" wrote: I ... 27 May 2010 17:04

Date Ranges
I am using excel 2007 and I have 4 columns; acct no, bill amt, enter date, eff date. I want to flag the records somehow if the "eff date" is with 90 days of the "enter date". Is there some type of formula or IF statement I could use? Thanks! -- Bruce ... 27 May 2010 17:04

Excel 2003 - importing info from closed workbooks
I am hoping to automate the extraction of information from a series of workbooks submitted by staff each week into a main spreadsheet. The importing information is laid out exactly in the same columns as the main spreadsheet but I do not know how many rows of information they may have input. What I would like ... 27 May 2010 17:04

IF Statement Yes/No
I am trying to write and IF Statement which will give me a "yes" if over 50% and a "no" if under 50% for below table Percent resolved 29% 38% 94% 67% 74% 63% 91% 81% Many thanks Rod ... 27 May 2010 18:11

Need help for multiple entries
Karl Put this formula in all the cells you want to match your input cell. In this case A1. =A1 Now when you enter anything into A1 it will show up in all cells that have your formula Mike Rogers "Karl" wrote: Hi I want to be able to put say the letter A in column A-1 but want a formula that... 27 May 2010 17:04

Algrebraic Functions
How would you solve a function with input 1 output 8. Then input 2 output 14. next input 3 output is blank then input is blank Output is 24. the input is blank and the out put is 28. Finally, the input is 6 and the output is blank. ... 27 May 2010 18:11

Convert numbers to hrs: min
Hello How can I convert the following numbers into hrs:min? I have tried every possible format (including custom) and I do not get the results I want (e.g. 15:45 18:40) I want to get the difference in time between these numbers. Thank you 1545 1840 2015 2300 2045 2105 1700 1815 1825 1840 1850 2000 1835 1... 27 May 2010 19:18