How can stop a 9 digit number from formatting scientific

  • Thread starter Thread starter Excell Rooky
  • Start date Start date
E

Excell Rooky

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!
 
Have you tried widening the column?

But I don't know what a pivot table/csv file means. Does this mean you're
having trouble in the CSV file?

If you're checking the CSV file by reopening it in excel, try checking the
layout using a text editor -- like NotePad.
 
I have had this issue with keeping fake credit card numbers in
spreadsheet for systems testing purposes. To stop the number from bein
autoformatted add a ' hanging comma symbol to th
beginning of the number.
 
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!
Click to expand...

If the "number" is a user id, why not make it text instead? Precede it
with an apostrophe as suggested.

Bill
 
Back
Top