Number to text format problem

[posborne]

A very simple task normally i know - but i need to convert a 12 digit
ean reference from number to text format.
When i do this through the normal route of formattting the whole column
it changes to 4.00511E+12 - obviously the ean ref to the power of 12
and rounded up!
Why???
The cell size is not a problem.
Hitting F2 to enter each cell and tabbing out will show reference as i
need it, but this will take me all day for a 70,000 line SS.
Any ideas!?

 

[Bernie Deitrick]

P. Osborne,

Try this. Select all the cells, and run this macro:

Sub ConvertToText()
Dim myCell As Range
For Each myCell In Selection
myCell.Formula = "'" & myCell.Formula
Next myCell
End Sub

HTH,
Bernie
MS Excel MVP
Not affiliated with Excel Forum