Thread: How to prevent a number stored as text from converting to anumber
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aaron Rubinstein Aaron Rubinstein is offline
external usenet poster
  
Posts: 3
Default How to prevent a number stored as text from converting to anumber
Perfect - thanks!


On Aug 14, 3:57*pm, Per Jessen wrote:
Hi

You have to format the reciving cell as Text like this:

ActiveCell.Offset(1, 0).NumberFormat = "@"
ActiveCell.Offset(1, 0) = Temp

Regards,
Per

Reply With QuoteReply With Quote