[libreoffice-users] Re: Can't get leading zeros in Calc

On 1-6-2014 19:03, Alan B wrote:
> On Sat, May 31, 2014 at 7:34 PM, Oogie McGuire <oogiem@desertweyr.com>
> wrote:
>
> > I'm tearing my hair out here.
.....

> >
>
> Oogie are you still thinking of tearing out hair or have you gotten a
> solution from the responses so far?
>
> If you're still in the hair tearing stage perhaps you might find the
> following useful...
....

A number NEVER has leading zero's. This has nothing to do with the fact 
that it can be displayed with leading zero's, if using the format 
functionallity of Calc.

Below is a good advise to determine if a field is a text value, or a 
number value


> 3. What is the data type of each of the spreadsheet columns you want to
> import?
>
> To see the data type of a value in a cell enter the formula
> =CELL("TYPE",<address>) in a nearby cell. The <address> should refer to the
> cell that needs to be inspected. Is the result of the formula "l" or "v"?
> The first result is a lower case letter L the second is much more obvious,
> a lower case v. <address> needs to be a cell reference, e.g. B5, not the
> literal <address> that I've written here. The actual formula would look
> like =CELL("TYPE",B5) to find out the data type in cell B5. Repeat the
> formula for each column that is loaded into the database. Will want to know
> what type of data is already in each column.



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted