Hi all Today is a sad day because tomorrow MS will close the Excel newsgroups. I want to say that I hade a great time in the Excel groups the last...

Hi When iam typing number (14 digits) in excel which is .csv format it is giving error 8.9029E+12 like this i tried to format in general, number, text but...

I sorted my nearly 7,000 entries to add a detail in one column and saved the addition. How do I return to the original data-entry order and keep that as the...

I need to use Conditional Formatting to shade a few rows on data based on their value. Problem is there are cells with zeros and some are empty. I need to...

Looking for help... I manage a closed ticket report and I need to find a formula that will find all tickets in a certain time range. For instance, in the...

The Transportation Bureau at the New York City Police Department has lots of people who know all sorts of things about moving traffic, but none of us knows...

I've got 4 digit text nums in A1 down In B1 down, I would like to list the corresponding number of permutations, eg: 7777 1 1777 4 0044 6 ...

Not sure where to start with this formula but I need a single formula that results in multiple possible answers. Here is what I have If E3 = "U6" then...

I have spreadsheets going easily from 16000 to 64000 lines, I used to make EXCEL 2003 charts by using 3-4 worksheets easily. They were big but ran very...

If you use a drop down menu list with data validation, the menu is so small you can't read it. How do you apply normal formatting to improve the situation...

When using Excel, I receive an error message telling me that there is not enough system resources to display completely. Anyone have any idea what this means...

How to stop selecting multiple cells with one click in Excel 2007

is it possible to change the color of all cells that contain a formula or are part of a formula??? if so, how would i do that?

I have a variety of bids and am attempting to pick the lowest bid above a minimum of 50% of the current price (since presumably anything less isn't...

Over the last few days, I have sought and received help from the community. The help has been with formulas requiring array answers. Each time I try the...

We are converting to new software and want to import project data from the old system. I import the text file (I think it’s a print file as text) and skip...

Hi, I have a value in Cell A of ABC123. I want Cell B1 to contain the 123 from this cell. Can anyone tell me the formula to enter in B1. I'm sure I've seen...

How do you calculate days between dates BUT not count the SAT & SUN in that range? I know you have to change everything to days of the week, but how do you...

I cannot find an answer to this problem anywhere, perhaps someone here can help. I have 2 columns of data that I pulled from my proprietary database using...

I need to print 53 Excel worksheets 50 of which will have multiple printed pages and I need each printed page to display column headings by repeat printing...