I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one column.
I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one column.
put 1 in an empty cell, then copy that cell
select the 3500 prices
Goto Edit>PasteSpecial and tick the Add box
Exit
Clear the cell with 1.
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"R.Lee" <[email protected]> wrote in message
news:[email protected]...
> I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one
column.
Type $1.00 on any cell, copy that cell, select all 3500 prices and use paste
special; Values and Add.
L.
"R.Lee" wrote:
> I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one column.
Try this:
Enter the number 1 in a blank cell
<edit><copy>
Select the cells to be impacted
<edit><paste special>
Check: ADD
Check: Values
Click the [OK] button
Done
(Click the [ESC] button, to clear copy mode)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"R.Lee" wrote:
> I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one column.
You are my Hero!
"Leamsi" wrote:
> Type $1.00 on any cell, copy that cell, select all 3500 prices and use paste
> special; Values and Add.
>
> L.
>
> "R.Lee" wrote:
>
> > I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one column.
Thanks! Your on my Christmas card list now!
"Ron Coderre" wrote:
> Try this:
>
> Enter the number 1 in a blank cell
> <edit><copy>
> Select the cells to be impacted
> <edit><paste special>
> Check: ADD
> Check: Values
> Click the [OK] button
> Done
>
> (Click the [ESC] button, to clear copy mode)
>
> Does that help?
> ***********
> Regards,
> Ron
>
> XL2002, WinXP
>
>
> "R.Lee" wrote:
>
> > I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one column.
You are a lifesaver!
Thanks!
"Bob Phillips" wrote:
> put 1 in an empty cell, then copy that cell
>
> select the 3500 prices
> Goto Edit>PasteSpecial and tick the Add box
> Exit
>
> Clear the cell with 1.
>
> --
> HTH
>
> Bob Phillips
>
> (remove xxx from email address if mailing direct)
>
> "R.Lee" <[email protected]> wrote in message
> news:[email protected]...
> > I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one
> column.
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks