| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 45407 | 2004-05-21 09:17:00 | Excel functions | bk T (215) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 238186 | 2004-05-21 09:17:00 | I wish to create an invoice template using Excel 2003 but encounter the following problems: 1. How do I generate an Invoice No. whenever the worksheet opens - this Invoice No. has to be in running order, e.g. the first invoice is 0001 and when I open the next invoice I want it to generate (automatically) the number as 0002, and so on. 2. I want to insert a static date in a cell. The Excel Help says that all I have to do is press Ctrl + . I did (pressing Ctrl and the + from the number pad keys) but unfortunately, nothing happens. Cheers |
bk T (215) | ||
| 238187 | 2004-05-21 09:23:00 | best not to reinvent the wheel. head over to www.acclaim.co.nz and do it properly. Turn off the cashbook in setup and you have a good invoicing system. | wotz (335) | ||
| 238188 | 2004-05-21 10:08:00 | mr excell is quite handy Here (www.mrexcel.com) | johnboy (217) | ||
| 238189 | 2004-05-21 10:46:00 | > 2. I want to insert a static date in a cell. The > Excel Help says that all I have to do is press Ctrl + > . I did (pressing Ctrl and the + from the number pad > keys) but unfortunately, nothing happens. The instructions in Excel are to press CTRL + ; That means press "CTRL" and at the same time press ";" Do NOT press "+", thats not what it is telling you. The + indicates that you press the CTRL key as well as the ; key |
godfather (25) | ||
| 238190 | 2004-05-21 11:14:00 | Thanks godfather. Silly me, overlooked it's "Ctrl and semi-colon"! :p :8} | bk T (215) | ||
| 1 | |||||