Forum Discussion
Solved
Need Excel to Stop Reformatting Numbers
I can't get Excel to leave my numbers alone. I've set my column to "Text" in the format settings, but nothing I do in the number or other format settings is having any effect. It's been going on for ...
- Precisely how are you importing the data? Have a look at this page: https://jkp-ads.com/articles/importtext.asp I know it is for WIndows Excel, but this uses very old technology which has been around for decades so I expect Mac Excel has this feature too.
Precisely how are you importing the data? Have a look at this page: https://jkp-ads.com/articles/importtext.asp I know it is for WIndows Excel, but this uses very old technology which has been around for decades so I expect Mac Excel has this feature too.
Perfect... thank you. I've been using Excel for a couple of decades now and have never had it be so persistently obstinate with imported data. I've always set my import up in a text doc as plain text—not RTF—, simply copied and pasted, and have been able to make that work, with the occasional nuisance to correct. After all these years, I've never used the data import function you pointed out, allowing me to specify import parameters. I guess it's a lesson in "never too late to learn".
Thanks again, Jan.
- Glad I could teach you something new! :-)
