[Trlog] TR Log. Changing from .fff to NNNN serial number

[Ron Rossi]

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 at 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 at 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 at 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 at contesting.com
>>> http://lists.contesting.com/mailman/listinfo/trlog
>>
>> _______________________________________________
>> Trlog mailing list
>> Trlog at contesting.com
>> http://lists.contesting.com/mailman/listinfo/trlog
>