Formatting Numbers as Text

[reberryjr]

I'm going batty here. I have a large set of records where I have a 14 digit number, that comes over as scientific. I need to have it display the entire number, but it has to be formatted as text. If I double click in the cell (activate it), I get what I need. I can't do that with the size of the record set. Any suggestions?

 

[gruntingmonkey]

Can you select all the cells that need the formatting, right click, go to format cells and under the Number tab, select Text?