Changing Text to Number Format

[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

 

[JS]

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

 

[debi]

Yes please send it to me at (e-mail address removed)
Thanks!