http://snipplr.com/language/visual-basic/tags/Value Recent snippets posted on Snipplr.com en-us Tue, 21 May 2013 17:42:52 GMT 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/9862/check-for-duplicate-value-numeric/

]]> Mon, 17 Nov 2008 16:02:49 GMT http://snipplr.com/view/9862/check-for-duplicate-value-numeric/ http://snipplr.com/view/9861/check-for-duplicate-value-text/

]]> Mon, 17 Nov 2008 16:00:06 GMT http://snipplr.com/view/9861/check-for-duplicate-value-text/