View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excell Rooky Excell Rooky is offline
external usenet poster
 
Posts: 1
Default How can stop a 9 digit number from formatting scientific

I am completing a pivot table/csv file for Government Legislation
requirements and my user id number for submitting the information keeps
reverting to a scientific number which is unacceptable to the government site.
I have tried and better tried formatting the cell, gone into tools/edit etc
but to no avail I am running out of time for submission - help!