Forum Discussion
SpencerCurtin
Oct 04, 2022Copper Contributor
How to get excel to automatically store numbers as text when copy pasting.
I use excel to upload files online and I'm having an issue where the numbers keep getting truncated and dropping any decimals. I've tried using the number formatting as text but that doesn't work. However, I've found online that if I use the Text to Columns and in the third step chose text as my column data format then it won't drop the decimals when I upload the file.
Is there any way I can make it so that the numbers automatically get formatted this way when I copy/paste? I would rather not have to do it every time if I don't have to.
No RepliesBe the first to reply