Good afternoon RJohnson701CTS

Try using this VBA code to do what you need.

Sub FixNum()
For Each UsrCell In Selection
UsrCell.FormulaLocal = UsrCell.FormulaLocal
Next
End Sub

Copy it into a blank module, highlight the problematic numbers and then
call the macro. This will convert all the "text numbers" to actual
values.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=388704