ExcelBanter - How to prevent a number stored as text from converting to anumber

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to prevent a number stored as text from converting to anumber (https://www.excelbanter.com/excel-programming/432440-re-how-prevent-number-stored-text-converting-anumber.html)

Aaron Rubinstein

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

All times are GMT +1. The time now is 01:44 AM.