View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
miles miles is offline
external usenet poster
 
Posts: 6
Default Scientific notation in text cells

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)?

--
milesd