View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Morefeus Direct
 
Posts: n/a
Default how to add a % to amounts in excel

thanks JE that worked out fine , another question is there a way to convert
a^ (shift +6) delimted.dat file to a csv file ?

help!
M johnson


"JE McGimpsey" wrote:

Enter your increase in a blank cell, e.g., to increase by 6%, enter

1.06

in a blank cell. Copy the cell. Select the prices to change. Choose
Edit/Paste Special, selecting the Values and Multiply radio buttons.
Click OK.

In article ,
Morefeus Direct <Morefeus wrote:

i have the stadard excel worksheet up , now in line A i have prices all the
way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
to each of these price value, with out having to do one at a time , how do i
do this?