How can I convert text w/embedded commas to number?
C CLR Jul 16, 2005 #3 Depending on your specific data.........maybe the Edit > Replace function, or maybe just Right-click > FormatCells > and re-format the cell......... Vaya con Dios, Chuck, CABGx3
Depending on your specific data.........maybe the Edit > Replace function, or maybe just Right-click > FormatCells > and re-format the cell......... Vaya con Dios, Chuck, CABGx3
M Michael Jul 18, 2005 #4 In a blank cell type a 1 and copy. Select the column of text and go to edit - paste special - multiply. This will convert all to numbers and remove the commas. HTH
In a blank cell type a 1 and copy. Select the column of text and go to edit - paste special - multiply. This will convert all to numbers and remove the commas. HTH
