I have this VBA code that copies and paste and it works great except when I have this in a cell: 744350E00, when I run the code it changes it to 7.44E+05. I wanted to keep the same format. Below is the code. Can the code be modified to not convert it to a scientific format?
.Value = .Value