General

month function
Is there a way to use the month function so that if 12 is inputed, December will be the output? Rather than the reverse. I tried =Month(12) but that doesn't return December. Could you help me please?! Thanks! ... 7 Jul 2008 16:38

page setup chaged when I used different computer
I had cutomized page margin setting and when I opened the file in a different computer the page margin setting has been changed...probably what was default on the latter computer. For example, the the spreadsheet was fit all in one page and on the second computer the last row goes to the second page.... How... 7 Jul 2008 12:30

Open and Close a Workbook to Update Links
I have a file that is linked to another file on the same shared drive. When I open the file, the links to the other file don't update. However, when I open the other file the links DO update. I wanted to just open the file I'm linked to and then close it using a macro, but this doesn't work either. I'm usin... 7 Jul 2008 15:36

Hide the answer to an equation until all values are inputed
I am trying to hide the answer to my equation until all the values have been put into the spreadsheet. Anyone know how to do this? ... 8 Jul 2008 03:53

autofill timestamp
I have a table with over 4000 records collected with a gps every second, but the timestamp it gives does not make sense (eg.78419863). I am looking for some help to calculate the values of a field so that it takes the first record of the field and adds 1 second to each record after the first time. Is it possibl... 7 Jul 2008 12:30

Graph Creation in Excel
All, I don't know if this is possible, but here goes. I have a number of entries in a spreadsheet, showing me date / time of access and a site. For example: 01-07-2008 09:15:34 Aberdeen 01-07-2008 09:15:37 Aberdeen 01-07-2008 10:10:10 Glasgow etc. What I need to show is a graph that lists t... 7 Jul 2008 18:41

filter a column from other sheet.
Is it possible i can type a value in a cell and excel filter in specified sheet&column by this value? kind regards thanks ... 9 Jul 2008 05:29

Prefix in every cell
I would like to place a prefix for suffix in every cell, either or. I need to place a part number that starts with the same tow letters, say PL, and then I would like to only type in the part number but have the prefix in the same cell, exp. type in 097886 and have PL097886 appear in the cell. Is this do-able. ... 7 Jul 2008 16:38

not equal to
Hi there, here is my problem: I would like use a conditional formating formula. If A2 is not equal to 0 I want B2 red. What is the "not equal" sign? = equal < smaller than bigger than but "not equal"? ... 7 Jul 2008 08:23

Problem with Save As
Hi, While using Save As functionality, i am puttin Square Braces "[ ]" in the file name. e.g abc[1].xls. But getting a weired error saying This file could not be accessed. Try one of the following. * Make sure the specified folder exists. * Make sure the folder that contains the file is not read-only. * Make... 7 Jul 2008 10:26