Recent snippets posted on Snipplr.com https://snipplr.com/ Tue, 09 Jun 2026 19:32:08 +0000 https://snipplr.com/view/49080/excel-copy-value-from-cell-with-custom-format <p>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</p> Wed, 16 Feb 2011 10:56:25 UTC https://snipplr.com/view/49080/excel-copy-value-from-cell-with-custom-format