| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 51431 | 2004-11-20 22:29:00 | OT - entering dates into Excel | annie (6010) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 294479 | 2004-11-20 22:29:00 | My accountant has a clunky Excel spreadsheet into which I have to manually type my statement entries, line by line, each month. It drives me nuts to have to type the date in full, e.g. '01oct04' rather than being able to use the numeric keypad to enter '011004' and have the date come up in an acceptable format. Americanising the date doesn't help either, nor any of the other thrashings around I've tried. My "Teach Yourself Excel' book is no help either. The field is not used for calculation. I suspect I'm stuck with this, but would welcome any helpful suggestions from more experienced Excel users. (New accountant is not an option at the moment) |
annie (6010) | ||
| 294480 | 2004-11-20 22:48:00 | Annie, If you select the date cells in Excel and then click Format, Cells..., you can select the date format displayed by the cell. I don't think you can enter the date in the format "011004" but you could enter it as 1/10/04 which still uses the backslash on the numeric keypad. |
Tristan Speak (465) | ||
| 294481 | 2004-11-20 22:52:00 | IT WORKS!!! Thank you so much - I hadn't thought to try that Annie |
annie (6010) | ||
| 294482 | 2004-11-21 00:22:00 | A lot of banks now offer internet banking services, one of which is the ability to download your bank stmt to a text or excel file. Cut & paste from this would be a lot easier than maunual entry and less errors! | jeep (1673) | ||
| 294483 | 2004-11-21 03:27:00 | Thanks - yes, I've also got Cashbook Compete, which is brilliant. Trouble is my accountant won't use anything but his own spreadsheet....I've pointed him towards Cashbook, but so far no progress - | annie (6010) | ||
| 1 | |||||