#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Fixing cell value

How can I prevent the value of a cell from changing when created by a formala
at a given time and then use it again in other formala's
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Fixing cell value

Convert it to values. (Edit|copy, edit|paste special|values is one way)

Pieter wrote:

How can I prevent the value of a cell from changing when created by a formala
at a given time and then use it again in other formala's


--

Dave Peterson
Reply
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
Fixing cell color changes when copying in Excel 2007 nataliemichelle Excel Discussion (Misc queries) 2 July 1st 07 04:33 AM
Fixing Last Cell [email protected] Excel Discussion (Misc queries) 4 January 24th 07 12:15 AM
Fixing some bugs daddioja Excel Worksheet Functions 9 June 19th 06 06:31 PM
Fixing multiline cell TonyL Excel Worksheet Functions 2 April 6th 06 02:14 PM
Fixing a single cell reference keeping others dynamic Engineering Intern Excel Worksheet Functions 1 July 1st 05 07:09 PM


All times are GMT +1. The time now is 12:03 PM.

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

About Us

"It's about Microsoft Excel"