Thread: How to make excel to treat values in cell as a number?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default How to make excel to treat values in cell as a number?
set cell = Range("B9")
cell.NumberFormat = "General"
cell.Value = cell.Value

' or for extra assurance

cell.Value = cdbl(cell.Value)

--
Regards,
Tom Ogilvy


"Peri" wrote in message news:op.szt6nxbky8ffpb@mcs...
How to make excel to treat values in cell as a number?


Reply With QuoteReply With Quote