Number to text format problem

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!?


---
Message posted from http://www.ExcelForum.com/

Bernie
Wed Dec 24 06:56:59 CST 2003

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

"posborne" <posborne.yxqkm@excelforum-nospam.com> wrote in message
news:posborne.yxqkm@excelforum-nospam.com...
> 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!?
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>