PartTimeExcel
New Member
- Joined
- Dec 9, 2020
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
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!
With PS.Range("A:A")
.NumberFormat = "general"
.Value = .Value
End With
Thanks for taking a look!