I am exporting a report in exel format, however, for customer identifiers that are more than 12 digits, the exel displays them as decimals eg 9876520220007 is displayed as 9.88E 12 or as 9.876520220007. This makes it very hard to verify data because the customer identifier is used to check if the records are correct. Any recommendations or links on how i can display the full number will be apreciated. Thanks

My data:

CodePudding user response：

Select the column and right-click to format cell, and set the decimal place to 0 that should do the trick. but I see you have different types of data in the column you might need to update it individually depending on the case

but I see the

CodePudding user response：

How are you getting the data into excel? Is it via a csv?

In which case you can use the get data from file option which lets you specify the column type as text before excel messes with it.

You can also set the column format to text. This doesn't fix the ones that excel has already interpreted as a long number but any new ones you paste or type in will stay as text.

You can also put an apostrophe before the text in the cell which forces it to be text.

Thats the only one I can suggest up to now as I don't know how you are getting the data into excel.