Forum Discussion
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 type is text (tab or comma delimited). When I open the file in excel, some number such as 453542521655884033 turns automatically into 453542521655884000 (notice the last two digits change); I believe it is a number that Excel can't handle. However, I am fine to keep the field as text and not numbers or General but keep the original value even if it is a text. I tried multiple ways, but it is not working. How can I solve this issue?
Regards, Farah Haddad
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
1 Reply
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