how to convert text to value
I have 40 thousands database of excel spreadsheet to convert from text eg.
12+3 to value. I tried many ways in doing but not success. Please help. thanks |
Sally,
Select all the cells that you need to convert, and run this macro: Sub TryNow() Dim mycell As Range For Each mycell In Selection mycell.Value = Evaluate(mycell.Text) Next mycell End Sub HTH, Bernie MS Excel MVP "Sally" wrote in message ... I have 40 thousands database of excel spreadsheet to convert from text eg. 12+3 to value. I tried many ways in doing but not success. Please help. thanks |
All times are GMT +1. The time now is 02:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com