Hello, When I have this number, 268435457800737937, Excel gives me an error when I do the DEC2HEX formula. In an online converter, I get 3B9ACA06B551480....

Hi, see table below. Col A Col B Col C a 1 7 s 4 9 x 8 4 d 9 3

I have a large excel (Excel 97) file on an NT4 server. When I try to open the file (across the network) on my computer - XP pro with office2000 premium edition...

hi, I have the below data...like this i have huge data in different sheets(which are named date wise) and i can not consolidate them in a single sheet as the...

When I open a worksheet, created in a english version of=20 Excel, which have a button attached to the=20 macro "auto_open" The swedish version of Excel...

How to remove error notification when X7/M7=0 when one or both cell values are 0

I've got a daily time-tracking spreadsheet. The formula in A4 is: =(A2A1)+A2-A1+(A3B2)+A3-B2 (A1 = Start Time, A2 = Lunch Begin, B2 = Lunch End, A3 = End...

Hi I need to create a pivot table .... it could be revenue per. country. Let us assume that there are 30 countries. I only want to display top 10. I can find...

Was this function removed from 2007 or do I just need to download an add-in?

I am trying to use sumif function to add up a range in excel using color as "CRITERIA". Is this possible? or is there another way to go about it? Thanks.

Hi, i posted earlier asking for conversion to pounds. i meant to ask for a conversion form kilos to stones and pounds (i.e 15 kilos = 15 stone 2 pounds NOT...

I am working with several large excel sheets(stats, employees etc.). I am trying to tie all 4 of these sheets into 1 sheet that will pull data from the main...

I have been researching and trying to figure out how to get a spreadsheet do some counting for me. I am on active duty with my National Guard unit on a...

Hi All I have data listed in rows that I want to display in columns which will then be used in another program and I can't use a pivot table. ...

I have 10 columns and 5 rows of cells. All cells do not contain a number and the cells which DO contain numbers are sometimes 1, 2, or 3 digits. I need to...

when I try to print a blank worksheet I have customized in order to input by hand (pencil), it will only print the headings I have typed in and not the...

I have applied the registry patch described in http://support.microsoft.com/kb/831824/ but it does not seem to notice this if the subtotaling is done inside a...

Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...

I am a teacher and have an excel spreadsheet (2003) with student's marks in various columns. Each column represents a quiz/exam/OP or assignment and they are...

Hi see your response in Excel.misc (for on possible solution). Please don't multipost as this create additional efforts for all who responds two your...