Forum Discussion
Solved
Excel Changes the value of the cell automatically
Hello, I have a question, please. I am downloading a list of product Hierarchy (18 digits alphanumeric or numeric number) from SAP. If it happens to be a number, then the numbers are long; the file ...
Hello fhaddad
You need to import the file as a text.
From Data tab --> from Get & Transform Data group --> From Text/CSV
from the open window select your file --> click on Transform Data -->
From the Power Query Editor window, click on the number 123 on the column title (see photo) --> change it to text --> click on Replace current--> click on Close & Load on tools bar
Hello fhaddad
You need to import the file as a text.
From Data tab --> from Get & Transform Data group --> From Text/CSV
from the open window select your file --> click on Transform Data -->
From the Power Query Editor window, click on the number 123 on the column title (see photo) --> change it to text --> click on Replace current--> click on Close & Load on tools bar