so other than that its just gonna drop the zero. OK well i have tried it and i like how it asks you how you want to import the spread sheet before you use it gives me a chance to set that feild to text.
Brian On 6/8/05, Anthony Chilco <[EMAIL PROTECTED]> wrote: > Hi Brian, > Yes, it's the same function and takes the same parameters. Calc uses the > semicolon rather than a comma as a delimiter. If you want your model > numbers to retain leading zeros you can format the cell to require six > digits. Or you could precede the number with an apostrophe: > '098367. This forces the format to text. > tc > > Brian Parker wrote: > > >Microsoft excel has a function vlookup ( ) does calc have a similar > >function, and if I have a model number like 098367 will calc turn it into > >98367 can cost me a lot of money? > > > > > > > >Brian Parker > > > >ELECTRONICS DEPARTMENT > > > > > > > > > > > > > -- Brian Parker (Woods) http://www.file-heaven.com/ CO Owner & Head Designer & Programer --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
