When I save an Excel sheet in CSV format, some of the text data is saved in a date format. Example 04-96 in Excel is saved as Apr-96, However this is not a...

Hi All, I have a form using Excel 2002 with eight cells requiring user entry. With these cells being unprotected while the sheet was protected, Excel 97...

I have fullname column with first, middle initial, last name. Some of the names do not have middle initials. Example John W Meadows I want to replace it...

how do you get the window with the list of current files and the other options (such as 'new') to be open when you get in there. Mine flashes for a second the...

Previous assistance worked but required me to type in the VB code. Is there any way to create the macro using the recorder (not typing in code)? I need a macro...

I transferred data from one excel file to another. Upon transferring the data as Value only, the new excel file is capturing a hidden character in the new...

Anyone know how to transfer a time (hh:mm) into a rounded decimal? example: 3:08 to be 3.25??? --- Message posted from http://www.ExcelForum.com/

Is it possible to specify a particular worksheet for a workbook to open at? Eg. Open file 'Employee.xls' at worksheet titled 'Dave' I can't find any relevant...

Hi, I have a list vith names and now I´d like to get the names in a form, a time sheet, for every name in the list. Is there a simple way to do this? Thanks...

Is there a way for Excel to automatically execute (on loading) a macro and then close? I'm trying to get it to automatically load--print...

In the Options Tab on Excel worksheet I clicked the general tab and where it said 'At start, open all files in' I inadvertently typed c:\documents and...

I have a large spreedshett(800 lines) I clikced on DATAFILTERAUTO FILTER and the arrows shopwed up on the various col. One of these Col is called DATE I...

I am attempting to create a macro that will take the active file and "save as" in a mmyy format. Anybody know how to do this? --- Message posted from...

I just installed a new printer (hp business inkjet 1100) and now in Excel, my right margin will not move any further to the right that 3/4 inch from the edge. ...

I received the following message when dragging my "Products" item onto my Pivot Table. "A field in your source data has more unique items than can be used in...

I need an IF formula to display TRUE or FALSE depending on what text is contained in a cell. Eg. Column J Contains differnt record types: 'New...

Hi , In cell B5 of sheet2 I have the following...

Hi I am trying to replicate an expenses sheet & it has vrious heading under which you have a '+' which when you click on it gives you several new blank rows...

Let's say that I make a logical test...the test is true and it displays a certain value... Example: =IF(A10;"blablabla") (the logical test is "A10" and the...

I want to protect a cell (e.g. C5) after entering a formula (e.g. C5=C3+C4). But at the same time the entire worksheet except C5 should be unprotected/open for...