Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 3rd 14, 11:59 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2014
Posts: 1
Default Delete Numbers in Column, Leave Formulas in Column Intact

Is there a quick, easy way to do this?

Thanks.

  #2   Report Post  
Old January 4th 14, 07:39 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,685
Default Delete Numbers in Column, Leave Formulas in Column Intact

Hi Mike,

Am Fri, 03 Jan 2014 18:59:19 -0500 schrieb Mike:

Is there a quick, easy way to do this?


no, that is not possible.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
  #3   Report Post  
Old January 4th 14, 07:42 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,685
Default Delete Numbers in Column, Leave Formulas in Column Intact

Hi Mike,

Am Sat, 4 Jan 2014 08:39:26 +0100 schrieb Claus Busch:

no, that is not possible.


or format the cells custom with ;;;
If you want see again the result of the formula format "General" or
"Number"


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
  #4   Report Post  
Old January 4th 14, 09:25 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,685
Default Delete Numbers in Column, Leave Formulas in Column Intact

Hi Mike,

Am Sat, 4 Jan 2014 08:42:44 +0100 schrieb Claus Busch:

or format the cells custom with ;;;


or set font color to white


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
  #5   Report Post  
Old January 5th 14, 12:46 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,685
Default Delete Numbers in Column, Leave Formulas in Column Intact

Hi,

Am Sat, 4 Jan 2014 10:25:18 +0100 schrieb Claus Busch:

or set font color to white


or press CTRL + #


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2


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
Changing column of numbers made of formulas to just numbers CJ Excel Discussion (Misc queries) 2 June 14th 06 02:13 PM
delete some cell formulas and leave others using code john tempest Excel Worksheet Functions 0 February 23rd 06 03:51 PM
Delete text while numbers remain intact Sugar_grrl Excel Worksheet Functions 2 August 15th 05 05:32 PM
How do I clear a worksheet of values, but leave formulas intact? [email protected] Excel Worksheet Functions 2 April 18th 05 05:53 PM
Sorting columns left to right leave a intact Todd Excel Programming 3 April 1st 04 11:16 PM


All times are GMT +1. The time now is 07:21 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017