ExcelBanter - Excel 2000

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/35596-excel-2000-a.html)

MOTMIIH

Excel 2000

How can I convert text w/embedded commas to number?

Anne Troy

Example please?
*******************
~Anne Troy

www.OfficeArticles.com

"MOTMIIH" wrote in message
...
How can I convert text w/embedded commas to number?

CLR

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

"MOTMIIH" wrote in message
...
How can I convert text w/embedded commas to number?

Michael

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
--
Sincerely, Michael Colvin

"MOTMIIH" wrote:

How can I convert text w/embedded commas to number?

All times are GMT +1. The time now is 08:48 PM.