Forum Discussion
Excel always automatically turns value I insert into gibberish numbers.
Hi all, I am working on this file inserting data into .csv file. Tha data include several sets of numbers separated by commas (eg. 24126,341255,512581, and so on) Whenever I insert them into...
Hi Riny_van_Eekelen,
Thank you for your advice.
I tried doing this but when I close and reopen the file, excel stills automatically change the format to scientific.
Is there a way to permanently disable this function?
Thank you for your advice.
I tried doing this but when I close and reopen the file, excel stills automatically change the format to scientific.
Is there a way to permanently disable this function?
Hi - I doubt it can be permanently disabled but you could try to enter the number with a leading single quote (') as a comment character.
Also, make sure to not save the file as csv or all formatting and the apostrophe as well will be lost.
Also, make sure to not save the file as csv or all formatting and the apostrophe as well will be lost.