sorry for my bad english.
I got master sheet (https://docs.google.com/spreadsheets/d/1n1vkc2uLpR9mNUA2hWXCNjJxN6cP05FvLF9o0Aledys/edit#gid=0)
There is all product codes and names with all the data.
Problem is when i use =importrange (https://docs.google.com/spreadsheets/d/1ijB6rAPB-aL5-NPMmZoVOQ4fRdaZn-owoeESc2-ArLE/edit#gid=0) in other sheet some codes like 130.20 zero gets deleted and code appears as 130.2 and then formulas like vlookup dont work.
I tried formating as plain text it does not fix a promblem.
Maybe someone know a workaround?
Thank you.
I tried formating as plain text and it only help in first sheet where data is paster but when i use =importrange 0 at the end get deleted.
Šarūnas Prakapas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.