Formatting Problem:scientific notation

[Martin]

After reformatting a long column of numbers (12 digits), some of my numbers get converted into scientific notation. To get them to display as a whole, i then F2 and and then press ENTER for each one

Is there an easier way than a potentially long F2 ENTER ?

[tonywig]

Could it be the column width that is the problem?

[Martin]

No it is not the width of the column. It is that some of the data was a TEXT format and others are either GENERAL or NUMBER.