Friday, April 4, 2014

yogi_Format a List Of Numbers To Have Minimum Number Of Specified Digits ... With Leading Zero(s) As Needed

                                         Google Spreadsheet   Post  #1588
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Apr-04-2014
post by Simone Pompei: (!category-topic/docs/spreadsheets/cnZHLx0mQxQ)
numbers with initial 0 is turned in number without that 0
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.
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?