VBA to Convert number from Scientific Notation to a normal number with no decimals

[PartTimeExcel]

Hi, I'm needing to know how to convert a long number that defaults to scientific notation (12 digit numbers) into normal numbers without a decimal point. The below code changed it from text to general formatting, but the length of the number is putting into Sc.Note.

With PS.Range("A:A")
.NumberFormat = "general"
.Value = .Value
End With

Thanks for taking a look!

 

[Joe4]

Just choose a Number format with zero decimals instead of "general", i.e.

With PS.Range("A:A")
    .NumberFormat = "0"
    .Value = .Value
End With

 

[PartTimeExcel]

Well played.

I had tried to do it with #s and that did not work.

Thank you!

 

[Joe4]

You are welcome.
Glad I was able to help!