Hello,

I have received an excel file from a client that is giving me fits. The
issue at hand is my inablility to convert a formatted column from number to
text, without it reverting back to scientific notation.

What is happening is that the column shows a numeric value, such as
17055201480000. When I try and paste that value in the adjacent column,
which I have pre-formatted as text, it changes to 1.70552E+13. And when I
look at the value in the edit/formula bar it shows as 17055201480000.

So I try it another way by creating a new column, leaving the formatting
alone (general by default), and then use copy/paste special/values it pastes
it as 17055201480000, and then when I go to change the format of the column
to text it reverts back to 1.70552E+13.

I know that there is a simple solution, but I am stumped. How do I do this?

Thanks in advance for your replies.

Phil