Changing Text to Number Format

  • Thread starter Thread starter debi
  • Start date Start date
D

debi

Please help!

I followed the directions to convert text to numbers on
the help menu to no avail, nothing will work.
It is data that I copied in and I really need a solution -
- I can't seem to get it to convert to anything.


Thanks for your help
 
hi debi

the following macro should do it. highlight the problem cells and run the
macro. if you have any problems using it let me know and i'll send you a
spreadsheet with the macro in it.

Sub FixCells()
Dim cell As Range
For Each cell In Selection
cell.Value = cell.Value
Next cell
End Sub
 
Back
Top