| Thread | Last Post | Replies |
|
| Auto fill numbers and text | 25 Jan 2008 19:23 GMT | 1 |
I need to fill out a column for file numbers that are combination text and numbers. The files follow the format ABRE1234.tif. It won't let me drag and fill the series with the ".tif"
|
| Where is this in Excel 2007 ? | 25 Jan 2008 19:21 GMT | 11 |
In Excel 2002 I can goto: Tools>Customize>Options tab>Always show full menus If this is still available in Excel 2007 I can't find it! I went to the MS site where they have an interactive app that shows where
|
| name listings | 25 Jan 2008 19:16 GMT | 1 |
I have several name lists in which each of the names are entered in single cells as first name last name, is there a formula to reverse the order? Example' Jane Doe changed to Doe Jane within the same cell.
|
| Multi selection copy problem | 25 Jan 2008 19:14 GMT | 2 |
when i multi select cells from one sheet and copy and paste in another sheet it copies the cells that i doidn't select them too what is wrong with my excel? any help would be so appriciated
|
| How can I capatalize text in a column? | 25 Jan 2008 18:25 GMT | 5 |
I would like to select a column to incorporate only upper case letters. How do I do this?
|
| Pivot Table with Data replace error | 25 Jan 2008 18:22 GMT | 1 |
I have a template with pivot table (without VBA code). I am getting a message after downloading data from application to my template with "Yes" "No" buttons. If I click on "Yes" its working fine. The message dialog prompts with the following meesage.
|
| Mirror Columns accross worksheet | 25 Jan 2008 17:59 GMT | 6 |
I want column A in sheet 2 to mirror column A in sheet 1 using VBA. Anybody? Thanks, Duncs
|
| Security on an attachment | 25 Jan 2008 17:46 GMT | 2 |
Is there anyway to prevent an excel worksheet from being attahced to an email?
|
| Numbers change to Date error | 25 Jan 2008 17:24 GMT | 1 |
I have downloaded a CSV file with 55000 rows of data in it, into an excel worksheet. Before importing, the sheet is formated as TEXT, for all columns. It has 3 columns in it: Price, Description, Replacement Number. I get back errors on some of the numbers. A number like ...
|
| Link comments | 25 Jan 2008 17:22 GMT | 2 |
Can comments be linked? ie I have a cell in a workbook that is linked to a cell in another workbook. The contents are linked, but is there a way to link the comments? - in Excel 2003
|
| Graph bars are sticking | 25 Jan 2008 17:11 GMT | 6 |
I created a graph (3 records data from April-03 to Mar-09) with chart type bars but output graph looks like the bars are stacking. Can any one suggest me what needs to be done to see if the bars will line up beside each other (not supposed to be stacked bars)
|
| Processes in one cell | 25 Jan 2008 17:06 GMT | 2 |
I am working in the HR department in a BPO Industry. Last week, my manager has given me a tedious task. I have to prepare employee master of 5000 employees of around 85 different processes. I have prepared that sheet by combining many existing sheets. Now, I have to update that ...
|
| multiple email accounts | 25 Jan 2008 17:00 GMT | 2 |
I have set up two email accounts, but all messages are 'received' by the default account. Can we set Outlook to recive the incoming messages to the appropriate Inbox? I've already set the default mailbox to view by email account, but we would
|
| Help with dates as reminders | 25 Jan 2008 16:47 GMT | 3 |
I'm working for a car dealer that has payments due from Buy Here - Pay Here and I'm wanting to make a spreadsheet with all the people and when payments are due- Question is how do I set it up that the day it comes due the day would change a color and if so make alarm go ...
|
| importing numbers into .csv file | 25 Jan 2008 16:35 GMT | 1 |
In Excel 2003, when saving data from web-based accounting system into .csv, numbers stayed numbers. In 2007, anything over 999 has a space between hundreds, thousands, and millions and is treated as text instead oas a number. Can anyone help me
|