Forum Discussion
pasluy
Nov 18, 2020Copper Contributor
Text is not Text in Excel even the cell format is text
By copy data from another excelsheet i have a problem that, even the cells is text format Excel see it is not the same format. So if you make a pivot table de data gives an other position. I copy wit...
pasluy
Nov 19, 2020Copper Contributor
NikolinoDE Yes now attached the file
Wyn Hopkins
Nov 19, 2020MVP
If you want to convert them all to numbers then a quick way is to highlight all the numbers (don't including the heading) and then choose Data > Text To Columns > Finish
If you need them all to be text then it's more difficult, potentially adding a calculation column =Text(C5, "@") and copying that down
If you need them all to be text then it's more difficult, potentially adding a calculation column =Text(C5, "@") and copying that down