Re: [libreoffice-users] Date changes to a 5 digit number

Le 27/10/2012 18:59, . a écrit :
> I made a macro that inserts the date (fixed) as (for example) "July 30,
> 2012,"
>
> However, after running the macro a fews time the date then appears as
> some 5 digit number.
>
> How do I fix this date problem?

This seems to me like a formatting glitch. You get the date number [1] 
but you have to format it as a date with the options you need (can't be 
more specific WRT macros as I've got macrophobia).


[1] In spreadsheets, dates are stored and handled as integer numbers. 
They convey the number of days since a reference date, most usually 
December 30th, 1899.
--
Jean-Francois Nifenecker, Bordeaux

--
For unsubscribe instructions e-mail to: users+help@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