I want to place an x cell B35 and have C35 display 2 in it. What is the formula I need to use?

Yes I know, a similar question appears in the database. My problem is that I can't use custom formatting. Here's the deal. I want to copy 1s(superscript)1...

I've spent most of my day trying to ask VB to do this for me, but don't know how to communicate it correctly. I have column A in "List"(Sheet1) with 150...

when entering data in a cell, i need to restrict users to enter the following alphanumeric combination and nothing more. "aa####a", where "a" is an alphabetic...

How can I create a formula to automatically transfer text from merged cells on one worksheet to a single cell on another worksheet? This would operate like a...

Data in word is presented as a bullet list. I have copied this data into a new doc and removed the formatting to leave just the list of items. I now wish to...

I have several macros written to update information in a spreadsheet based on an entry into a input box. I need to change these macros to instead look at a...

When I customize my toolbar, the changes do not stay when I close Excel. I tried to remane the .xlb file, but the changes still did not save. Is...

Acutally the close button, the big X on the upper right side, does close Excel, I just need to click it twice. While this really isn't a problem, It is...

How do I get Excel (2000) to stop asking me if I want to save changes when I've made no changes? I saw this issue addressed in Word, but the "fix" must not be...

I have a large dataset of the monthly performance of certain companies. example a1:a12 contain January till december of company A a13:a24 contain January till...

I have a pivot table that help me analyze a big amount of data. I examine several scenarios that depends on the selections that I make in the page fields. I...

Hi Everybody, is there any algorythm/function to know the size of given excel worksheet in byte? Tamas -- Tamas Nagy

i am trying to find the percent of times less than one minute in a range of times. times are formatted 00:00:00

Hi there! I work in Excel a lot and use the Find window A LOT. I typically search for a number, change some data, and search for the next...

I am looking for Excel return on investment (ROI) templates. Does anyone have any ideas?

I have a series of part numbers that include the letter e. ( EX: 38E275 ) Excel is treating these as Exponents (I thnk) and I see the value changed into...

I do not know if newer versions of Excel than I have have this function, but in working with a budget in Excel, it sure would be a nice feature to be able to...

How do I interpret (#,##0_);(#,##0) or other similar formulas so I can figure out what is wrong or create a new one for a specific situation? I looked...