Thursday, July 1st, 2010 Posted in excel, perl, programming, windows | Comments Off
If you want Excel to keep a field's leading zeros when opening a CSV file using Excel, you can change it to ="value". For example, if you have a row with ... Read more..Monday, February 8th, 2010 Posted in linux, windows | Comments Off
To avoid getting the error "Your operating system does not meet system requirements", I had to use User Agent Switcher to download the spreadsheet at http://office.microsoft.com/en-us/templates/TC300022771033.aspx for electric meter ... Read more..Wednesday, February 18th, 2009 Posted in productivity, windows | Comments Off
If you need to select the whole data region (it might included some empty cells) in Excel without selecting all cells (<CTRL>+<A>), click on any cell inside that group and ... Read more..