|
PureBytes Links
Trading Reference Links
|
At 10:57 AM -0400 7/12/99, DStan34930@xxxxxxx wrote:
>This is good. One caution that comes to mind though is that any
>ascii data files created from EL using the date function for the
>date column would be unreadable by any other software.
>
>i.e.
>"date","time","C"
>991231,1615,1340.50
>1000101,935,1400.00 ???
Below is an Excel formula that will convert a text string in cell B1
of the type:
991231
1000101
to the standard Excel date format:
<=VALUE(CONCATENATE(MID(B1,LEN(B1)-3,2),"/",RIGHT(B1,2),"/",TEXT(VALUE
(LEFT(B1,LEN(B1)-4))+1900,0)))>
(use the expression between the <...> with no spaces)
Perhaps some Excel experts out there can find a shorter expression.
Bob Fulks
|