AdWords
1.7K members online now
1.7K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

Excel converting GTIN

[ Edited ]
kem
Visitor ✭ ✭ ✭
# 1
kem
Visitor ✭ ✭ ✭

Excel is converting my GTIN to display 7.0549E+11. I'm using excel for Mac. When I click on it, it displays the GTIN correctly. How do I format the cell to display the GTIN correctly? I'm importing a .txt file. 

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by Emmanuel F (Rising Star)
January 2017

Re: Excel converting GTIN

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

Well, you can change the cell format in excel to number .Check gif below. I guess i got your question correctly.

 

Googledoubt.gif

View solution in original post

Marked as Best Answer.
Solution
Accepted by Emmanuel F (Rising Star)
January 2017

Re: Excel converting GTIN

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

Well, you can change the cell format in excel to number .Check gif below. I guess i got your question correctly.

 

Googledoubt.gif

Re: Excel converting GTIN

kem
Visitor ✭ ✭ ✭
# 3
kem
Visitor ✭ ✭ ✭
Thank you! That worked.

--
Kay