Hello
I have a list of numbers in column A (see attached file) that is formatted as text. If you are using vba code to copy over the numbers, what custom number format would you use to stop excel from converting the numbers to scientific notation.
.Range("A1:A").NumberFormat = "????"
Last edited by KenV15; 11-05-2023 at 05:22 PM.
I used the below and it converted the text to numbers and didn't change them to scientific notation.
It's a very small sample to work with, so doesn't mean it will work for all instances in your real data.
Please Login or Register to view this content.
BSB
Thank you BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks