I receive a weekly file from a tool that sometimes throws a "^" character in front of date. This symbol seems to be throwing excel off and I am unable...

When I open a new spread sheet the highlight goes crazy all over the page and I cant stop it. To get out of it I always need to use Ctrl.Alt.Del. Now I cannot...

i have this formula =SUM(E3:E11/B3:B11), i want to divide the sum of the E column by the sum of the B column but am obviously missing something that will seem...

I have read the previous posts about merging cells, but I am lost. Is there a formula to merge 5 cells, with a space between each that I can apply to...

Is there a way to convert an existing phone number format to this type of format ###-###-#### without rekeying the numbewrs

I have a spreadsheet with 12 rows that goes for many columns ( with formulas). Is there a way to print this where three pages are on each piece of paper?

I am trying to figure out how excel, or any other office program, can help me with the scheduling of incoming trucks for my business. I have 4...

How do I remove the page numbering in the middle of pagebreak preview and still remain under pagebreak preview mode.

I emailed an Excel file to a colleague. It was sent as an attachment in Thunderbird. The recipient - who uses Outlook - saved the spreadsheet to disk. Now if...

is there a quick way to multipy a large group of numbers by 1,000?

This was originally posted in the "excel.programming" ng as "Command Button test changes size" on Apr 29th, to no avail. Thought I'd try it here (with some...

Hi There. So each time I change a cell the auto sum does not add up the change just keeps the original summed figure there....until you click on Save. The...

Hello there, would there be a way to hide the Worksheet Menu Bar for one particular workbook only, and have a macro button to unhide the Worksheet Menu Bar...

Hello is there a way to dis-able the unhide sheets toolbar? TIA, Ditchy

I need to write a formula that will recalculate itself every 24 hours without any intervention from humans. I have no idea how to do this.

I have a master price list containing different work sheets for different brands and also I have different files with each brands prices o it. The individual...

Hi all, I have a range of value such as 1, 1, 2, 3, 6, 6, 8 etc....I want to copy it to an other worksheet but i do not want to see the two 1s, and the two 6s...

I am creating a costed roster spread sheet. I would like to be able to calculate amount of hours between entered times and result be displayed in decimal...

Hi, I've constructed a tool that employs multiple Userforms and several incidences of Date and Time Picker Controls (version 6.0). Amongst the group that...

Hi, I'm using Excel 2003 to do some actuarial work. I notice that if a very large number of random number is generated(say 10000), and the spreadsheet is run...