Forum Discussion

cchai's avatar
cchai
Copper Contributor
Jun 02, 2023

The annoying excel scientific notation

I have a column which is the supplier item code, it contains text or a long barcode (so it is not pure long "number" barcode),  e.g. ABC123456 1000000000000000   The data are from some source th...
Excel
Cangkir's avatar
Cangkir
Brass Contributor
Jun 02, 2023

cchai 

Assuming the formula shows original number, maybe this way:
Use macro to add apostrophe (') in front of the numbers.
Something like this:

Sub to_Text()
Dim c As Range
 For Each c In Range("A2", Cells(Rows.Count, "A").End(xlUp))
    c = "'" & c.Formula
 Next
End Sub

Before

After

Resources