How can I turn off Picture Mode in Excel 2007 Compatibility Mode? After I cut, copy, and past data into another spreadsheet, the data is locked and formatted to Picture Mode automatically. I am currently running XP with Office 2003. 

Hello!

I have a Microsoft Excel document used to calculate percentage options:

– For items that cost $20 or less I charge 20% but minimum $3

– For items that cost more than $20 but less than $35 I charge 15% but minimum $5

– For items that cost more than $35 I charge 10%, but minimum $8.

I’m looking for a formula to use for both the cell for the amount and the cell for the result, without using a third cell for the percentage.

Does anyone know how to do this? 

Hi!

I am working on a data entry project with Microsoft Excel and I have a problem. My data comes in two long columns:

In column 1A I have: SC-

In column 1B there could be any number made of 1 to 4 digits, sometimes combined with letters (e.g. 23, 32.65b or D48)

What I want is to add the numbers and letters in column 1B to the SC- in column 1A. This may be a very tedious process if I use the F2 key to do 1 row at a time.

I want to know if there’s any way to combine the two columns in A so I get mixed numbers and letters (e.g. SC-23, SC-32.65b etc.), leaving the B column untouched.

If you have any solution, please let me know

Hello!

I have Windows Vista installed on my computer and I can’t open an excel file received as attachment in an email. Every week I receive an email with updates and I can’t get to open the attachments.

Is there any problem with my connection?

Is there any way I could solve this problem? 

I am experiencing a problem with my Microsoft Excel. Whenever I try starting a macro in an existing spread sheet, I encounter an error message saying “It appears that you have opened it using Internet Explorer.

Please download the spread sheet to your computer and open it using Excel”. It somehow worked after a long time but then it suddenly stopped working again.

I already tried looking at the file associations and I thought I saw something wrong but I still could not correct it.

I hope you’ll help me deal with this problem. Thank you. 

My computer’s operating system is Windows XP and I am using Microsoft Office 2007 with it.

My trouble is whenever I open an Excel file; it opens but has no data on it. Microsoft Word works just fine but Excel does not.

I even tried uninstalling and reinstalling Microsoft Office 2007, and made sure that all updates are done to no avail.

I hope you could tell me what the problem is and how I could solve it. Thank you. 

I am currently testing Microsoft Office 2007 to determine if my company should upgrade from Microsoft Office 2003.  One of the things I tested was the Microsoft Excel. I tried running an important spreadsheet that was originally created in Microsoft Excel 2003.

The spreadsheet ran on Compatibility Mode however, any information that has been modified such as formatting, color, format, font style and font size is lost after I close the file.

Recreating the files takes up too much time and has become intolerable, that I have to run all the files in Compatibility Mode for now. I even tried downloading the Microsoft Office 2010 Beta but I eventually had to rip it out because it was too buggy.

I need help in figuring Microsoft Excel out. I have this Excel file where I input dates in some columns.

The problem is whenever I right-click the cell, the date format changes.

I tried restarting Microsoft Excel and even tried formatting the cells but the changes kept on happening.

I hope you’ll be able to help me.

Thank you

We have existing grade sheets with shading and borders. As grades are added, the borders get messed up. When someone copy-pastes from a cell, the border from that cell is copied to the new cell. Can the shades and borders be retained while other users are putting in data? Do I have to set an editable range and protect the rest? How?

After having some Windows updates a user rebooted his computer and after that he lost his MS Excel file (2007) that was saved on his Desktop.

When where able to find the file back in his mail.