Copy one cell to entire column



This seemingly very simply question has me baffled. I have a column of data
that I need to perform an operation, something similar to '=f2-36161'.
Column F has the data in numeric format. I add a column, say Column G. Then
I put into G2 the '=f2-36161' and then convert this new number to a date
formatted 'mm/dd/ccyy'. I'd like to replicate (copy/paste) this G2
calculation and operation down through the entire Column G. [Column G is
about 15000 rows deep.]
Is there an easy way to do the copy/paste or replicate without copying G2
and then copy/paste MANUALLY down the column until I reach the end of the
data?
Seems like a simply question but I can't find the 'key'.
Thanks,
Tom
.



Relevant Pages

  • Req: help with DBD::AnyData test.pl in DBI::PurePerl configuration
    ... Argument "Tom" isn't numeric in numeric eq at ... Argument "Bev" isn't numeric in numeric eq at ... Copying SQL::Statement ... tar xzf SQL-Statement-1.09.tar.gz ...
    (perl.dbi.users)
  • Re: never ending problems
    ... Three times because when copying linked styles using the Organizer the ... Copying them three times works. ... "Tom G" wrote in message ... >> Since you are checking 'Add to Template' in a document attached to ...
    (microsoft.public.word.numbering)
  • Re: No Grace Period for Metabolism Either
    ... Hi again Tom. ... If I have 2 molecules, ... The only thing that I am claiming is that those who replicate themselfs will ... > Musea Review Service ...
    (sci.bio.evolution)
  • Write Conflict
    ... Copying the changes to the clipboard will let you look at the values ... Shafiee. ... Prev by Date: ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Stolen site
    ... Trish did not claim that her site was hijacked, ... John ... Prev by Date: ...
    (soc.genealogy.ireland)