Formatting Numbers as Text

reberryjr

Active Member
Joined
Mar 16, 2017
Messages
483
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

Active Member
Joined
Mar 6, 2008
Messages
386
Can you select all the cells that need the formatting, right click, go to format cells and under the Number tab, select Text?
 

Forum statistics

Threads
1,085,475
Messages
5,383,903
Members
401,863
Latest member
Sisma

Some videos you may like

This Week's Hot Topics

Top