General
in [Excel]
|
Formatting Text to Numbers for Dates I'm currently working with a column of dates. Some of the dates are text and some are numbers. The dates are in the following format 21/06/210 (mm/dd/yyyy). I used =isnumber() to verify cells. Half of the coulmn resulted in false values. I'm unable to format the dates to other formats, since some are text. ... 27 May 2010 18:11
How do I make nametags with pictures? How can I make nametags/badges with pictures? ... 27 May 2010 19:18
rows truncated when printing I export spreadsheets from another programme to excel. The imported font size is 8 point. When I increase the font size to 10 for better printing the rows increase on screen, but in print preview or when printed, the row height has not increased and the text is truncated. I have wrapped the text and autofitted ... 27 May 2010 17:04
Bankup of worksheet Thanks you Mike for reply it's working fine. Thanks Again. One more thing i am useing excel2003 is there any good book for excel2007 or any PDF file from net. Thanks "Mike H" wrote: Hi, Try this. Note I used XLSX as the file extension because I'm using e2007 so change to the apppropriate one fo... 27 May 2010 17:04
Find I have numbers in column A that don't belong such as; 74-350-77-50 18-350-077-51 36-100-001-03 the 3rd digit should not be a "-" the rest of them would read 74350-77-50 18350-077-51 36100-001-03 What I need to do is find them and delete that row Any ideas? -- Randy ... 27 May 2010 18:11
keystroke shortcut needed Could anyone tell me what is the shortcut to select the used up cells in a column? -- Failing to plan is planning to fail ... 27 May 2010 18:11
naming worksheet tabs Thank you for your reply. -- Thanks, Sharon "Jacob Skaria" wrote: Sorry, you cannot. Max length 31 Exception characters [ ] * ? / \ -- Jacob (MVP - Excel) "SHARON" wrote: i need to name a worksheet tab with a name that is more characters than allowed. Ca... 27 May 2010 18:11
Return date of an action So simple but I would never have got there. Thanks very much "Jacob Skaria" wrote: Hi Ben In F2 use the formula and copy down =LOOKUP(2,1/(A2:E2<>""),$A$1:$E$1) To handle the error for blank rows use the below version =IF(COUNTA(A4:E4),LOOKUP(2,1/(A4:E4<>""),$A$1:$E$1),"") -- J... 27 May 2010 18:11
excel 2003 Hi I am using excel 2003 and everything was goin g fine until I tried to open a file (which was working ok) but now won t open and just comes up with the message "Time Sheet 09-10.xls:file format is not valid" any ideas on how I can either re save so it will open or any other ideads on how I access the info i... 27 May 2010 17:04 |