| Thread | Last Post | Replies |
|
| Conversion in EXCEL Numeric to Text | 29 Jan 2007 13:34 GMT | 2 |
I'am looking for VBA program inside EXCEL, which can convert numeric cells to text. Thank you Arnold
|
| Duplicate Remover | 29 Jan 2007 10:37 GMT | 8 |
I have 20,000 rows and five columns in which I need to compare the contents of all the cells in one row, remove (text) duplicates from those cells and merge them into a new cell along the same row with the data separated by commas. When I did not have duplicates and I merged
|
| Userform | 29 Jan 2007 09:54 GMT | 1 |
Hallo zusammen kann mirt jemand erklären - wie ich diese auf den Desktop bringe und so ohne start von Excel aufrufebn kann! Danke für jeden Tipp!
|
| In Excell-2000 where do I set format for date? | 29 Jan 2007 09:03 GMT | 5 |
In Excell-2000 where do I set format for date? In some tables I have it in dd/mm/yy, but in the others mm/dd/yy How do I change mm/dd/yy to dd/mm/yy? On my w2k Pro, Control Paned date format is set to dd/mm/yy yout it does not
|
| compare two columns and write out the delta | 29 Jan 2007 08:49 GMT | 2 |
How can I use 1 col (col 1) of numbers as master, compare another column (col 2) to it, then write out everything in col 1, but not in col 3 to another col? Thanks
|
| Conditional Format in a List | 29 Jan 2007 03:45 GMT | 2 |
I am creating a Template and need a little help with automatic row shading.I have the data entry area set up as a list with a total row and have set up the following conditional format to shade every other row =MOD(SUBTOTAL(3,$A$4:$A4),2)=0This conditional format is only applied ...
|
| Date prob in excel 2000 | 29 Jan 2007 01:28 GMT | 3 |
I have a workbook with a far amount of data in it that is quite old ie. 6 yrs. Tow problems 1. One of the office girls decided to clean her keyboard while the file was
|
| worksheet with same name error | 29 Jan 2007 01:17 GMT | 9 |
I have a macro that I use to make a copy of the active worksheet . It works great, if I run the macro again with the same value in "f4", I get a vb error. Is there a way to check the name in "f4" against all worksheet names (there could be 50 sheets) and trap the error?
|
| Colour by clicking cell | 29 Jan 2007 00:07 GMT | 12 |
I am searching for a way to change background colour by click in a cell and back to normal colour by clicking it again. Is this possible? And if how is it don? Thank you in advance.
|
| Office 2007 Group | 28 Jan 2007 23:43 GMT | 4 |
Is there an Office 2007 Group? is any one using office 2007?? I love it!
|
| Horizontal axis in middle of chart | 28 Jan 2007 21:16 GMT | 1 |
Hi, I have a line graph where the vertical axis goes from -15 to 30. The horizontal labels then appear in the middle of the chart where the zero line is, how can I get the labels to be below the chart on the -15 line? I am using excel 2007.
|
| Click From List (again) | 28 Jan 2007 18:16 GMT | 5 |
This si a repeat becauise I could not find the original or a response on the group. A cell on a spread sheet has (mysteriously) acquired a reaction which as far as I can see is "Click From List"
|
| Delete Row | 28 Jan 2007 17:52 GMT | 3 |
In Excel, I need a macro that will delete an entire row based on a name entered into an input box that would match a worksheet with that name in column "A". Thanks,
|
| Is there any way to make unlocked cells visible when the sheet is locked? | 28 Jan 2007 14:54 GMT | 4 |
Is there any way to make unlocked cells visible when the sheet is locked? Bart XP/Ex 2003
|
| 2003 Macro Issue | 28 Jan 2007 14:19 GMT | 4 |
Hey guys, I am wondering if anyone can help me, I have a macro to save a copy of an excel spreadsheet that works fine in Excel 2002 but in 2003 gives a debug error.
|