http://snipplr.com/language/visual-basic/tags/format Recent snippets posted on Snipplr.com en-us Sat, 18 May 2013 22:55:49 GMT http://snipplr.com/view/69167/format-header-range/ quick way to get column headers formatted

]]> Thu, 20 Dec 2012 02:56:27 GMT http://snipplr.com/view/69167/format-header-range/ http://snipplr.com/view/49080/excel-copy-value-from-cell-with-custom-format/ Excel macro to copy values from formated cells. For example: If you have a sheet that has huge numbers in millions for example 1,312,323 and you apply a format to the cell such that only 1.3 is displayed, if you want to copy 1.3 and put it in a database (without the format) use the following snippet. Select all the cells you want to apply this macro and run it. Note: this will convert the cell values to string

]]> Wed, 16 Feb 2011 10:56:25 GMT http://snipplr.com/view/49080/excel-copy-value-from-cell-with-custom-format/ http://snipplr.com/view/7457/access-vba-date-formatting/

]]> Wed, 23 Jul 2008 06:14:18 GMT http://snipplr.com/view/7457/access-vba-date-formatting/