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

Hello,

I've tried to achieve this with macro recorder, but it writes only the
".select" part...
(I used to select the whole range and than pass through the contextual <!
menu that appears briefly on the left side of the cell and signals the
problem...)

What is the VBA instruction for this?
Many thanks,

Mark

P.S: Range("B3").Select
Selection.NumberFormat = "0.00"
is not functionning in my workbook neither...