One of my additional duties at my office is running the weekly and monthly statistics for our ticketing system and sending the information to our corporate office. The ticketing system exports the information as a CSV file and the ticket numbers originally show up like this: 2.01308E+15. When I format that colum for numbers with no decimal places the ticket number displays but the final number for each ticket is changed to a zero. So instead of 2013070910000025 I see 2013070910000020. Then I have to to to each cell and encapsulate the ticket number in quotes with an equals sign at the beginning, and change the last digit to its actual value for the correct ticket number to be displayed. Can anyone tell me if there is a better way to accomplish this? Is there a setting I need to change, or a formula I can use? Changing each cell is time consuming!
Bookmarks