I am saving my worksheet as a Formatted Text (space delimited). One of the cells has 256 characters. When I open the txt file, the column has wrapped to...

I have a project start and end date and have calculated the amount of time based on those dates. I have # hours that will be spent on that project. I need...

I have a problem importing dates with 2 digit year format. When importing dates with a 2 digit year format, the conversion doesn't follow the regional date...

I have a table with the months in row 6. Revenue is in row 9 and costs are in rows 10 through 38. Cell c6 is 1 for January and cell c9 is January revenue. ...

Below is a formula that I have set up for a multiplier in my "Cost Estimator" worksheet In column D8 to look up the cost entered in D7 and mark up to the...

Hi I have found and am using the formula =A1&B1&C1 And that works fine but I can only get it to work on one row at a time. How would I get this to work on...

how do I open Open Office Calc with Excel

I have a workbook that has multiple worksheets. I would like to name the worksheets and used a macro that I found in one of the threads: Sub...

I am running XP and using Office 2003, have been for several years. Now Excel won't open. I get a message asking for the Microsoft Office Standard for...

How do I select non-contiguous cells in Excel 2007. I tried using the ctrl button like I did in 2003, but it's not working.

Several spreadsheets are only 50 rows or so but CONTROL + END takes me to cell H57459. The irritation is that the sliding bar on the right is a tiny one and...

With Excel 2003, is there any way to output comments when creating a CSV file? Similarly is there any way to input a specific cell from a CSV field into a...

Good afternoon, I am trying to create a macro to hide certain columns on a spreadsheet, how best do i do this, say want to hide columns g, h, u, ac & ae

When printing from ts 2008 tha in comments change. Any ideas why and how to avoid it. -- MKM MCSE,MCT,MCDBA,MCTS,MCITP

i am trying to highlight the entire row say if column H has a value greater than 1200. but column H has a formula and gets the input from another...

How to know address cell if there are max value exm : A B C 1 10 11 15 2 12 16 15 3 13 15 15

Excel is appears to be backing up files on it's own. Excel appends the file name with "Backup of .........xlk" and saves file as an .xlk not a xls file. ...

Hi, I need to concatenate three seperate Text fields in to one long string, but keeping each value to 30 char. eg A1 "999 Letsbe Avenue" B1 "Little Doing...

Hello, I would like to get rid of 'blank' label that appears in some blank cells in pivot tables. I just want it to appear blank. thank you.