How do I add the same dollar amount to all cells in excel?

's Computer Specifications

's Computer Specifications

Pt it in an empty cell, format as currency, copy it, select the cells you
want to add it to, do edit>paste special and select add

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

"CNewman" <(E-Mail Removed)> wrote in message
news:C53CFE4E-788F-45BC-AD43-(E-Mail Removed)...
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing Row by Row - A-D dollar amounts to E dollar amount	Mel	Microsoft Excel Worksheet Functions	9	20th Nov 2008 10:50 PM
extract covert dollar value in text cell to just dollar value	=?Utf-8?B?S2VsbHk=?=	Microsoft Excel Misc	2	4th Nov 2004 07:33 PM
Convert Number(dollar) to Text(dollar)	Michael Chong	Microsoft Excel New Users	1	26th Oct 2004 10:23 AM
Format Number(Dollar) to Text(Dollar)	Michael Chong	Microsoft Excel Misc	1	26th Oct 2004 10:19 AM
Evaluating values in cells (an Array?) and returning a dollar amount	Beth	Microsoft Excel Worksheet Functions	1	17th Aug 2004 09:02 PM