Threads Replies Last Post 326 Pages: <<  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  >>   Convert to time How would I go about converting 8.00 to 8:00:00 AM in excel. Can this be done? ... 13 21.08.2006 19:00:33 Excel General Hi there, If I have two columns of numbers in an excel spreadsheet is it possible to put in some formulae or some other function thatlist out the common numbers in both the columns. Basically I need to eliminate the #'s in column A that figure in Column B too. Thanks for the help. Cheers, Srini -- sjanaswamy ------------------------------------------------------------------------ sjana... 2 21.08.2006 18:20:00 Random 8 digit number? I need to know the formula to create a column of random 8 character ID numbers, preferably with a set prefix of 3 numbers. I'd be REALLY happy if I could create it with random text and numerals, but it doesn't have to be. (where 123 is the constant) i.e.: 12386756 12337288 12378645 12321356 or 123g568e 1237t7er 12397u23 Thanks in advance for your help. Kenny ... 7 21.08.2006 17:35:28 convert number to text how to :- 100 convert to One Hundred only and 100.30 convert to One Hundred and 30 Cent only -- xman123 ------------------------------------------------------------------------ xman123's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35532 View this thread: http://www.excelforum.com/showthread.php?threadid=573842 ... 2 21.08.2006 17:28:20 Commands for cursor moving right, left, up, down. Hello, Sorry maybe for a basic question. Trying to make a macro within MS Excel (automatic VSB scripting), I get commands moving the cursor to a particular named cell instead of moving the cursor to the "right", left etc. Editing the macro, what are the commands just to let move the cursor to - right - left - up - down Ages ago I made some simple macro's in Lotus 123 in such a ... 5 21.08.2006 17:25:14 custom number format is there a way to format a number so that: if there are decimal places, you see: 1234.56 (which includes the "." character), but, if it is a whole number, the display is: 1234 (without a decimal character, i.e. not "1234.") ##0.## is not correct, since it always displays the "." character... thanks in advance, mark ... 2 21.08.2006 17:23:18 Help! Error Message = No program is registered to open this File Fellow forum members: I'm totally confused why all my Excel hyperlinks don't work and display the messages below everytime I select one: "Some files can contain viruses and otherwise be harmful to your computer. It is important that the file comes from a trustworthy source. Would you like to open the file?" "No program is registered to open this File" The first message is just annoying ... 5 21.08.2006 17:20:50 Auto transfer of row/ update Hi Im trying to setup a system for our 'goods in' the attached sheet would be on a pc at the 'goods in ' area hooked up to our network. In the office we have a individual parts list for each job. I want to be able to input a component on the parts list and when I enter a order number in the cell at that row it will copy the row to a row on the attached sheet (goods in). When the tick box is ticke... 2 21.08.2006 16:33:51 Excel error When I try to format a cell in a workbook, I am getting an error "Too many cell formats." Does anyone know how to fix this error? Thanks in advance for your help. -- jeanst ------------------------------------------------------------------------ jeanst's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37819 View this thread: http://www.excelforum.com/showthread.php?thread... 2 21.08.2006 15:12:44 auto input in next cell this is the formula in cell L84 =D84+G84+J84 but if i enter a value in K84 then i would like L84 to change to that value. -- just1creation ------------------------------------------------------------------------ just1creation's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35468 View this thread: http://www.excelforum.com/showthread.php?threadid=573247 ... 4 21.08.2006 15:04:54 "headers" Is there a way that a header row can be printed on each page of a multipage document without manually inputing the header row at the start of each page. We may be adding more information to a page that will cause the "page breaks" to change on each page. Thank you Ann -- aletoconstco ------------------------------------------------------------------------ aletoconstco's Profile: http://... 5 21.08.2006 14:35:47 Rounded Result with Goal Seek When I use Goal Seek, the result cell returns a calculated value of, for example, 55.6138. I would like to have this value rounded to 2 decimal places i.e. 55.61. Does anyone know a method by which this can be accomplished? Thanks for any help, Crownman ... 7 21.08.2006 14:12:08 Best way to count these? I hope someone can point me in the right direction to count whether certain cells have a value. Beginning in Column C, every fourth column (C, H, L, etc) out to Column DH may or may not have a value. I would like to count how many do have a value in each data row. Is there a formula that will do this? Or should I look at a macro? Ed ... 3 21.08.2006 14:03:49 Want average formula. I want to make this symmetry curve more smooth. these pair is 0 and 27, 1 and 26, 2 and 25, 3 and 24.........etc. the highest of curve is on center, and the lowest of curve is on two side. i try take pair points on two side, averages to a new point. it will be a smooth symmetry curve. how i do it by formula? thanks. 0 0 1 0.001724138 2 0.005172414 3 0.006896552 4 0.017241379... 6 21.08.2006 14:00:38 The instruction at "ox30033d8a" referenced memory I receive the message "The instruction at "ox30033d8a" referenced memory at "ox650918d8". The memory could not be "read". " when i close the excel file from VBA code like WB.close -- sandya ------------------------------------------------------------------------ sandya's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37816 View this thread: http://www.excelforum.com/show... 1 21.08.2006 13:46:23 Conditional Drop-down Posted: Mon Aug 21, 2006 9:17 pm Post subject: Conditional Drop-downs -------------------------------------------------------------------------------- Greetings, I have a question and if any of you guys could help, I would very much appreciate it... Let us say I have a database which looks like this...(this is not an indication of reality) :p Religion Sects ... 2 21.08.2006 12:18:26 How to hide a cell if a formula returns no value? HI again all, what I'm after this time is a way to hide a cell by using a formula. This is pretty much solely for formatting reasons so that the sheet can be cut and paste into word from excel without empty cells coming up. I need something like this; cell a1 contains "whatever is entered into cell a1" in cell a2 =IF(a1="",Hide cell a2,a1) not an overly useful example I know, but ho... 4 21.08.2006 12:07:15 Referencing ranges in different sheets Hi all, I'm quite new to VBA, so I apologies if my knowledge of code is a bit flaky. What I'm trying to do is a 'For-Each' loop through a large range. The code should check the corresponding range in a another sheet and if the value of that range is not empty, copy that range into the corresponding range in the current sheet. It should do this for each cell address (I think). With this frag... 3 21.08.2006 11:49:34 Please help me. presently I link b1 and f1 of "payment" sheet to d1 and e1 of another sheet. What function should I apply in e1 when I link b1 then in e1 cell the f1 value should reflect automatically. _*d1__*_ *_e1_* b1 of payment next 4th column's value Please help me. thanks in advance skaran -- kumawat_s --------------------------------------------------... 4 21.08.2006 10:51:13 Floating Legend Question Hello! I've designed a spreadsheet that details waiting times for patients in a hospital & assigns different colours via conditional formatting if the waiting times are out of the criteria set. (eg green = within criteria, red = not within criteria). As well the spreadsheet has a legend to show what these colours mean (as there are other, manually assigned colours) (SEE PICCIE!) Now, when ... 2 21.08.2006 09:52:04 Export Greek text to CSV Hi, I'm trying to export an XLS to CSV with excel. The XLS is in ISO Greek and displays properly in Excel. When I export the file all greek text comes up as question marks so I get a file that looks like : 503,????????? ??????????,??????? 62 ?,"?????? ?????????? Chris 526,?????????? ??????????,???????? ????????? 62,100m ??? ?? ?????? 598,???????? ??????????,????????? 3,"?????? ???????? ... 1 21.08.2006 08:50:30 help, formula to read results and paste to other document have document labeled for each week, within this there are 6 sheets, mon/tues/wed/thurs/fri/total i want the total for each person to be put into a other excel document, is this possible ?? if so how ? ... 5 21.08.2006 05:21:37 Excel and launching userforms Greetings, I want to do something that I hope is not too unusual. i want to test a value in a cell, and if it one thing or another... launch a user form. Here is the scenario... test cell a1, if it is greater than 10, then launch userform1, userform1 will ask a question, if yes is selected it will write some text "and" the contents of cell a1 to cell b1. How do you do this? Thank... 7 21.08.2006 00:39:45 Help with copy and paste. I have a spreadsheet which has an area for data, and then a summary table with conditonal formatting which changes the colour of the cells depending on the value. I would like to copy and paste this summary table into a new spreadsheet and preserve all the colour changes. How can I do this without copying all the data with it. I have tried but find that only the text and formats can be c... 3 20.08.2006 23:17:42 Copying Cells with Drop Down Lists This is a multi-part message in MIME format. ------=_NextPart_000_0021_01C6C496.879E8810 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable good Evening Fellow Excel Users I have a spreadsheet below which i created one Darts - League 2006-2007=20 Week 1 MATCH No 1=20 =20 Team A V Team B=20 =20 ... 3 20.08.2006 23:17:39 326 Pages: <<  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  >>