Is there any way to use hex numbers in excel besides using hex2dec? I create many charts where I get the data in hex. This conversion process is a real pain.

When I am selecting a single cell or column, I get that cell or column and the two cells or columns to the left of the selection also. I only want to select...

Hi, We have a main Workbook which we create several workbooks from, each of the copied workbooks contain only the relevant worksheets that are needed for...

On my budget page, there are negative numbers when an expenditure is more than the budgeted amount. I need these negative numbers to be added to the total...

I have a spreadsheet with numbers and text spread out across columns. I need to search across the columns by row and return to the "A" column the first value...

when I am on the cell the dark border around it is not showing. thanks

How do I format a number cell so when I enter any value in it, it shows the input value dvided by 1000? For instance if I enter 4565 the cell should show...

I have a spreadspread that contains both text and numbers in every column and row. The values are in euro. I usually copy the spreadsheet over and multiply...

In Excel 2003 you could create custom buttons and assign a macro to them. When you needed to use your macro you would just click on your macro button and it...

Dear Sirs, we observe a wrong import of float data from a text file generated by a C program via a printf("%f\t%f\n",a,b) where a and b are float var. We...

=IF(OR(D41="",F41=""),0,(NETWORKDAYS(D41,F41)-1)*("15:00"-"06:30")+MOD(F41,1)-MOD(D41,1)) I’m trying to calculate the non-working time accumulated by a...

does anyone have a way of tracking deferred revenue in MS Excel that is quick and easy?

Hello, I am trying to find a case sensitve v-lookup. I used the following vlookup but found it returned incorrect data because it is not case...

Trying to write a macro that takes a range of cells (J45:J2546) and checks to see if any of the cells in this range are less than 1. But it needs to verify...

I would like to track business contracts with a 5 year cycle. I want to allow sales people to begin prospecting new contracts within 18 months of the old...

Hi I need to have a spreadsheet searched and where there are complete blank rows I need to colour that row. I can't do this using conditional formatting as...

I have a spreadsheet with ~20,000 lines (using Excel 2003). I use a filter on the data to quickly access what I need. I added ~30 lines of data to the...

I'm working with a large database and trying to write a countifs function. Each part of the function works independently and some of them work together, but...

I keep getting the following message when I try to close a file "Cannot find 'C:\Program Files\Microsoft...

Hi: I am trying to write a macro which searches for names of companies listed in one file (Switch Accounts) on other file with data ("ord-dump). 'open file...