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

[rt_clay at bellsouth.net]

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