ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Delete Numbers in Column, Leave Formulas in Column Intact (https://www.excelbanter.com/new-users-excel/449669-delete-numbers-column-leave-formulas-column-intact.html)

Mike[_133_]

Delete Numbers in Column, Leave Formulas in Column Intact
 
Is there a quick, easy way to do this?

Thanks.

Claus Busch

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

Claus Busch

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

Claus Busch

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

Claus Busch

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


All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com