Or if you totally insist on the time looking right then try 00":"00 as
the format. The number is still stored as "1"
73 es God Bless de KK1L...Ron Rossi (kk1l@arrl.net) <><
QTH: Jericho, Vermont
My page: http://home.comcast.net/~kk1l
Kenneth E. Harker wrote:
> In Excel:
>
> * Highlight the column
> * Format -> Cells
> * Number tab
> * Choose "Custom"
> * In the Type dialog enter 0000
>
> That should force it to display four digits with leading zeros as appropriate.
>
> On Mon, Nov 19, 2007 at 07:41:23PM +0000, rt_clay@bellsouth.net wrote:
>> In my spreadsheet (gnumeric running under Linux) I just have to make sure
>> that the time column is imported as a text value rather than a numeric
>> value. Then the leading zeroes are kept.
>>
>> Sorry, I don't know if Excel has a similar option.
>>
>> Tor
>> N4OGW
>>
>> -------------- Original message ----------------------
>> From: "Dave Hachadorian" <K6LL@ARRL.net>
>>>> Import the Cabrillo into a spreadsheet program and replace
>>>> the freq column
>>>> with numbers...?
>>>>
>>>> Tor
>>>> N4OGW
>>> Importing a Cabrillo (with headers stripped off) into a
>>> spreadsheet is a handy thing to do, but I haven't found a
>>> way to do it without corrupting the TIME column. A time of
>>> "0001" (one minute past midnight) gets changed to "1" and I
>>> can't find a way to reconstruct the time column. If someone
>>> knows how to do this, I'd appreciate hearing from you.
>>> Thanks.
>>>
>>> Dave Hachadorian, K6LL
>>> Yuma, AZ
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> .
>>>
>>> _______________________________________________
>>> Trlog mailing list
>>> Trlog@contesting.com
>>> http://lists.contesting.com/mailman/listinfo/trlog
>>
>> _______________________________________________
>> Trlog mailing list
>> Trlog@contesting.com
>> http://lists.contesting.com/mailman/listinfo/trlog
>
_______________________________________________
Trlog mailing list
Trlog@contesting.com
http://lists.contesting.com/mailman/listinfo/trlog
|