Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2010

Sun 25 Mar 2012, 13:33 Delegate Monika said...

Monika has attended:
Excel Introduction course
Excel Intermediate course

Excel

I have to re-do invoices for our clients from time to time. When I'm trying to enter cashier number (i.e. 6017) it changes to a random (?) date. How can I change it?

Mon 26 Mar 2012, 09:12 Delegate Barry said...

RE: Excel

Hi Monika, I use 2003 but the solution should be the same. I think you have your number col/cells set to Date. Select the col/cells you want as numbers, right mouse, select Format cells, then Numbers then select General.
what you have at the mo' is this or something like it, yes/No?

21/06/1916
21/06/1916
21/06/1916
After doing the above or the equivilant in 2010 you will have
6017
6017
6017

Hope it works for you

Baz

Training courses

98.5 % recommend us

More live stats...

Training information:

Excel tip:

Excel 2010 Shortcuts - Start and End of the Worksheet

Did you know you can quickly move to either the beginning or the end of an Excel Worksheet using just a couple of keys on the keyboard?

Press Ctrl + Home key to move the cursor to cell A1

Press Ctrl + End key to move the cursor to the end of the current worksheet.

View all Excel hints and tips