LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Introduce Value in a cell with formula, option

I have a column with formulas in cells, but i want sometimes to introduce
values instead having the result of the formula. At the same time i don't
want to loose the formula in the cell. Perhaps a condition that cleans the
formulas and put cells blank?
Thanks!
 
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
preserve formatting option in pivot table option dialog box Dave F Excel Discussion (Misc queries) 4 May 8th 08 07:25 PM
Introduce decimal point in a list of values in column. ssb Excel Discussion (Misc queries) 2 December 17th 06 11:19 PM
please introduce sorting by colors in excel DCDK Excel Discussion (Misc queries) 3 October 3rd 06 01:32 PM
please introduce sorting by colors in excel DCDK Excel Discussion (Misc queries) 0 October 3rd 06 11:08 AM
Excel 2002 formula displayed not value formula option not checked Dean Excel Worksheet Functions 1 February 28th 06 02:31 PM


All times are GMT +1. The time now is 06:28 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"