Google Spreadsheet Post #1588
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr-04-2014
post by Simone Pompei: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/cnZHLx0mQxQ)
numbers with initial 0 is turned in number without that 0
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr-04-2014
post by Simone Pompei: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/cnZHLx0mQxQ)
numbers with initial 0 is turned in number without that 0
Hi,
i've a spreadsheet wich i use to create invoices for my clients. I have a tab where i have the invoice layout and a tab with the list of my clients with all their data.
Now.
Everything works if i use a query to gain the data choosing a client.
what is not working is the VAT number if it starts with 0 for example 02290690978. It turns in 2290690978.
If i try to change the cell format to normal text.. the query does not show anything.
How can i avoid that?
--------------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment