AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
1.8K members online now
1.8K 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 (Top Contributor)
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 (Top Contributor)
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