Want to insert a number in one cell of a worksheet and have it displayed as such. However it either rounds the number off or inserts a decimal point. I do...

I have two lists that should contain the same values. In Excel, they are in two columns. In the third column, I want to put the values that are in List A but...

After posting a question on this site, I followed the prompt very helpful advice and now have my wonderful order form of which I am very proud. I created a...

I have an excel workbook that uses active -x controls. It allows the user to model the performance of a micro-scale wind turbine (small device that fits onto a...

tried using SUBTOTAL function (XL XP) and it doesn't seem to work =SUBTOTAL(9,A1:A10) still gives total of rows 1 thru 10 even though i've hidden rows 5 thru...

how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43 (68 minutes and 43 seconds)

can anyone help me fix this problem?

Graham, Thanks for that Toolbars are back. See you tomorrow. Regards Don

Can I run microsoft office 2000 in a dell XP? Thanks MC

I have a list of products to be made. On the next column I have a Lookup function that brings up descriptions and info based on that list. I usually need...

I am making an inventory of movies I have, and I would like the sort the list alphabetically. However many movie titles begin with 'a' or 'the' and I would...

On a spreadsheet due to the size of it takes 5 pages to print it off. Currently I `set` each page as a print area then print so I have to do this 5 times in...

Never really delved all that much into Excel before - not to this level any way so I’m hopeing someone can hold my hand through this. It should be an easy...

I want lock a cell immediately when i entered a value. So that the user cant change the value what he entered. But it should be done automatically. The very...

Am new user and need assistance. How do I format a specific cell(s) to roundup using Excel 2000? Thank you

Hello all this is my first post im adequately familiar with Excel, but what i was wondering is i have a spreadsheet with a bunch of email addresses of clients...

Is there a way to protect a worksheet so that no one can change the Page Setup setting such as margins, paper size, orientation, etc. Protection on the Tools...

hi, i can't merge the contents of multiple cells by selecting a range. i cannot waste hours by entering the cell's address maunally. Is there formulla to do...

How do i set up total income and annual figures in excel?

Hi, I'm trying to make a sign in/out spreadsheet that will automatically fill out our time sheets. My problem is, the cell I am mimiking is blank, either...