--- In [email protected], Reinaldo Paul Pérez Machado <rpmgis@...>
wrote:
>
> /*Hi,
>
> Does anybody knows how to convert 5 digit numbers from Excel spreadsheet
> (sequential days starting at 1/1/1900) into plain text format?
>
> Thanks,
>
> Reinaldo
> */
>
Renaldo:
Do you wish to (or are you able to) add a column in excel that will contain the
date in test form? If so, you can use the function
"=TEXT(B1,"00000")" (without the quotes) in a new column -- and note that the
"B1" should be changed to refer to the source column (the column with the
date).
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Maptitude/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/Maptitude/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
