ADDING 30000 TO A CELL
NOW I COME BACK WITH AN #REF ERROR?
"T. Valko" wrote:
Try it like this:
Enter 30000 in an empty cell
With that cell still selected, copy that cell: EditCopy
Select the range of cells you want to add the 30000 to
Then: EditPaste SpecialAddOK
Delete the cell with 30000
--
Biff
Microsoft Excel MVP
"CONFUSED" wrote in message
...
THAT DIDN'T DO WHAT I NEEDED IT TO DO EITHER, THANKS THOUGH THE OTHER
CELLS
THAT I AM TRYING TO ADD 30000 TO HAVE DIFFERENT NUMBERS IN THEM THAT I
NEED
TO ADD 30000 TO. THANKS THOUGH
"Sheeloo" wrote:
Enter 30000 in a cell
Select the cells you want to add 30000
Choose Edit-Paste Special-Add
"CONFUSED" wrote:
I AM TRYING TO ADD 30000 TO A CELL BUT I DON'T KNOW HOW OR WHAT FORMULA
TO
ENTER I TRIED = $765,130.00+30000, WHICH GAVE ME WHAT I NEEDED FOR THAT
CELL
BUT IS THERE A FORMULA I CAN USE SO I DON'T HAVE TO DO THIS IN EVERY
CELL
THAT I NEED TO ADD 30000 TO?
|