LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zmr325
 
Posts: n/a
Default How do I get rid of formulas?

Hello,

I am new to excel and I am trying to learn how to hide formulas once I have
the data entered into a cell. Here is my question if for instance lets say
that in column c i have data entered from 2 to 100 and then say something
changes and I have to add or subtract 10 from each of those cells. Before
what I was doing in a blank column off to the side I would simply use this
=c2+10 and then copy down to the end and then cut and paste those results in
the original column. I don't mind doing that if when i cut and paste the
fomulas aren't pasted with the number. I just want the cell to be a number
by itself. THank you and I hope this makes sense.

zmr325

p.s. does anybody have easy formulas for a weighted moving average and an
exponential moving average.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array Formulas take waaaay too long... belly0fdesire Excel Worksheet Functions 7 August 8th 05 10:11 PM
Help, Urgent Excel Formulas are not calculating maashoff Excel Discussion (Misc queries) 1 May 3rd 05 12:25 AM
Problem with named formula's nathan Excel Worksheet Functions 0 January 21st 05 04:07 PM
Way to make Excel only run certain formulas on a worksheet? jrusso Excel Discussion (Misc queries) 0 January 12th 05 04:23 PM
calculating formulas for all workbooks in a folder Chad Excel Worksheet Functions 3 November 13th 04 05:22 PM


All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"