Tuesday, August 4, 2015

LG G2 mini Unboxing (Photos)

The LG G2 mini was released in April 2014 and has a 1.2GHz quad core CPU, 4.7-in screen, 2440mAH battery and runs Android OS. For complete specs, click here.






Wednesday, February 4, 2015

Print (write) checks using MS Excel with this template

 Print (write) up to 10 personal checks per batch with this Ms Excel template.

Download template from this google docs link.

By J.Archer (Own work) [CC BY 3.0], via Wikimedia Commons

Reminders
Please enable macros when prompted.
Create custom paper size for your printer 8" x 3" or 8"x5" and name it "check"

Entering data
Enter data in 2nd sheet - check info.
Enter "date" and "amount numbers" only. Excel will convert amount in numbers to words automatically.
Enter payee name in 1st sheet if you'd like to select it in a dropdown option in second sheet

Printing
Print 3rd sheet - "checkprint"
Select page range of of checks you want to print check1 is page 1 etc.
Select paper "check"
Insert check right side first in printer

Editing
3rd sheet protected to avoid accidental moving of textboxes
To edit, right click checkprint sheet then unprotect.
You'll probably need to edit checkprint sheet since banks have different check layouts.
To edit output of "amount words" column in checkdetail sheet press Alt+F11 then edit code.

References:
Cheque printing without special software or Printer with Excel
MS Excel: Convert currency into words