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

[Kenneth E. Harker]

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

-- 
Kenneth E. Harker WM5R
kenharker at kenharker.com
http://www.kenharker.com/