/*Hi guys,
Thank you very much Mlarue and Christine for the aid. Like the previous
problem regarding the perimeter, this was accomplished in a very simple
way. I have just exported the offending column (with the dates depicted
in the required way) together with an ID to CSV format. Next step was to
join data views and... Problem solved! No formulas, no formating. I
would like to share this.
Cheers,
Reinaldo*/
------------------------------------------------------------------------
mklarue99 wrote:
--- In [email protected] <mailto:Maptitude%40yahoogroups.com>,
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).
