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
--
Kenneth E. Harker WM5R
kenharker@kenharker.com
http://www.kenharker.com/
_______________________________________________
Trlog mailing list
Trlog@contesting.com
http://lists.contesting.com/mailman/listinfo/trlog
|