Scientific notation in text cells
F2 and precede with an apostrophe
This will change them to text without the SN
Gord Dibben MS Excel MVP
On Thu, 7 Dec 2006 11:04:01 -0800, miles
wrote:
I have been given an excel file with 16 digit account numbers that need
modification. I am running up against the 15 digit precision limit. Is there
any way to change the format for these cells to text without defaulting to
scientific notation (eg 2.1761E+15)?
|