Thread: macro for converting number stored as "text" (or preceeded with ') to "number" formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kaak[_78_] Kaak[_78_] is offline
external usenet poster
  
Posts: 1
Default macro for converting number stored as "text" (or preceeded with ') to "number" formatting

Sub test()
Range("G2").Select
Do
If Isnumeric(Trim(ActiveCell.Value)) Then ActiveCell.Value
Trim(ActiveCell.Value) * 1
ActiveCell.Offset(1, 0).Select
Loop Until IsEmpty(ActiveCell)
End Su

--
Kaa
-----------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...nfo&userid=751
View this thread: http://www.excelforum.com/showthread.php?threadid=55725

Reply With QuoteReply With Quote