PureBytes Links
Trading Reference Links
|
If you want to obtain a date in your situation using a formula instead of a
macro you might try the following formula =VALUE(A1&"/"&B1&"/"&C1) in cell
D1 of Excel . Then format the number, hopefully 2/14/75, using Format,
Cell, and Date. If the date you want is not included among the standard
ones presented try making a custom format. If you get a series of #####
marks it may mean that your column is not wide enough to accommodate the
cell's contents. Just widen the column. Good luck.
---------------------------------------------------------------
>> The date format shown on the first column is of this type :
>> 750214
>> A1 B1 C1 D1
>> 02 14 75 ?
>>
>> Now, the big question : HOW DO I GET IN CELL D1 THE DATE IN
>> mm/dd/yy format ? (which, in this case, should be 2/14/75 ).
>>
>> I'm good working with Excel 7, just NOT good enough ! :- )
>>
>
>Why don't you create an automatic excel macro for doing all the work ???
>
>What you wanna do, is put the slashes... betwee 75, 02 and 14 .... so
>start the macro, push the edit key which is F2 and the use the righ
>cursor, put the slashes, when finish, push Enter, push the down cursor
>and this is the end of the macro... Asign the macro to a key
>combination, and the only you will have to do is redo the macro 100
>times...
>
>Wish this works for you!
>
>
>Best wishes from Barcelona
>
>
|