I need to add rows to my checkbook register. When I click on the number of the last line & hit copy, I then hit the number of the next row & hit paste, but it is not adding another line. How do I do this?
Yes, you can do that by changing the number format. Either use the date format with an * in front of it (meaning that it will use your computer's date settings) or define your own custom date format such as "d/m/yy"
Go to the sheet and where it says General in the drop down menu, scroll right down to 'other number formats' and then select the curency and change the symbol to United Kingdom currency
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](http://i.ytimg.com/vi/msQoTuCsKJ4/mqdefault.jpg)
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](/img/tr.png)
Can I add a column between the check number and the payee column? If so what are the steps to do that? Tks
I need to add rows to my checkbook register. When I click on the number of the last line & hit copy, I then hit the number of the next row & hit paste, but it is not adding another line. How do I do this?
See the section about adding rows here: www.vertex42.com/support.html#solutions
Hi please provide me how to use =VLOOKUP(9E+100,Table1[Balance],1) formula
How to make a template on a bi weekly time sheet with firmulas
can I change date format to uk day month year
Yes, you can do that by changing the number format. Either use the date format with an * in front of it (meaning that it will use your computer's date settings) or define your own custom date format such as "d/m/yy"
Go to the sheet and where it says General in the drop down menu, scroll right down to 'other number formats' and then select the curency and change the symbol to United Kingdom currency