Re: How to paste an item multiple times in a column

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I don't know about SQL, but could you just give it a nice numberformat after
you've imported the data?

Rock wrote:
>
> Thank you Dave. That was perfect.. and fast!!
>
> I have another post about changing the decimal in the $ c column. For
> some reason they have come from the MySql database as.. 45.0000 (four
> zeros) That's okay in mySQL I guess, but for a flat hard copy it's
> better just two cents.
>
> Anyway I'll offer the post separately as per etiquette.
>
> Dave Peterson wrote:
> > One manual way is to select the cells that get the same manufacturer.
> > Click on the first and ctrl-click on subsequent
> > then type your manufacturer's name
> > but hit ctrl-enter (instead of just enter) to fill the selected cells.
> >
> > If you can pick out something in the product column (begins with M (maybe), you
> > could apply data|filter and just show those values. It might make it a bit
> > easier to add your data.
> >
> > Ps. If you click on one cell and shift-click on another, you'll select all the
> > cells between them.
> >
> > Rock wrote:
> >
> >>Sorry!
> >>
> >>
> >>>Re-describe your problem with some example data(do not attach a file).
> >>
> >>>Add column?
> >>
> >>There are many rows, each of them being a particular product. The row
> >>contains details about the product but it did not have a manufacturer
> >>column and we need that, so I added one at the beginning of the row.
> >>
> >>
> >>>Add each name at one time?
> >>
> >>These rows (products) are products from different manufactures.
> >>For example Epson may have 20 rows (products) HP 100 etc.
> >>
> >>
> >>>How is the data laid out?
> >>
> >>Apple 3 M4683G/A-g 235.0000 1
> >>Apple 4 M5983G/A-g 399.0000 1
> >>Brother 5 DR-200-g 249.0000 2
> >>
> >>Instead of having to put the manufacturer in one at a time. I want to be
> >>able to paste in several rows into the manufacture column at a time.
> >>
> >>Thanks
> >>
> >>Rock
> >>
> >>
> >>>Gord Dibben Excel MVP
> >>>
> >>>On Tue, 29 Nov 2005 10:25:24 +1100, Rock <1940@xxxxxxxxx> wrote:
> >>>
> >>>
> >>>
> >>>>Hi,
> >>>>
> >>>>I have had to add column with the manufacturer's name and as there are
> >>>>100's of products to each manufacturer I need to add each manufacturer's
> >>>>name at the one time if possible.
> >>>>
> >>>>At the moment it says I have a single cell and can't add to multiple ones.
> >>>>
> >>>>Any help here please?
> >>>>
> >>>>Thanks
> >>>>
> >>>>Rock
> >>>
> >>>
> >

--

Dave Peterson
.

Relevant Pages

  • Re: How to paste an item multiple times in a column
    ... One manual way is to select the cells that get the same manufacturer. ... Rock wrote: ... >> How is the data laid out? ...
    (microsoft.public.excel)
  • RE: How do I turn off ALL autoformat in Excel ? (I cant even type "J.
    ... Select all cells by clicking cell in top left corner ... I rock! ... "Dave a.k.a. Technophobe" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: I GOTTA take Gman outta my KF
    ... remember the first rock and roll 45 by Bill Haley and the Comets. ... Other than kids records, the first real records I had were Elvis's "Are You Lonesome Tonight", a Debbie Reynolds record,and a ... They did their Dark Side of the Moon tour, at about the same time as Led Zeppelin did their tour that year. ...
    (alt.support.diabetes)
  • guitarists that need to retire
    ... The top 10 guitarists who desperately need to retire! ... Dave Navarro Dave's the Anna Kournikova of rock. ...
    (uk.music.guitar)
  • Re: Locking/unlocking cells based on column headers
    ... Dave, thank you so much! ... could do this with a named range? ... The reason I am so concerned about the range having locked/unlocked cells is ... If Month(DateAdd("m", X, StartDate)) Mod 3 = 0 Then ...
    (microsoft.public.excel.programming)