Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Emmaus junkie
 
Posts: n/a
Default how do I delete numbers without deleting formulas

In excel 2003 how do I delete a column of numbers without deleting the
formulas in the column?
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

F5SpecialConstants.

Use the option buttons to select what you wish to highlight for deletingOk

EditClear Contents.


Gord Dibben Excel MVP

On Sat, 8 Oct 2005 13:13:02 -0700, "Emmaus junkie" <Emmaus
wrote:

In excel 2003 how do I delete a column of numbers without deleting the
formulas in the column?


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
Delete text while numbers remain intact Sugar_grrl Excel Worksheet Functions 2 August 15th 05 05:32 PM
Array Formulas take waaaay too long... belly0fdesire Excel Worksheet Functions 7 August 8th 05 10:11 PM
Count comma separated numbers, numbers in a range with dash, not t Mahendra Excel Discussion (Misc queries) 0 August 8th 05 05:56 PM
Sorting alphanumeric numbers maurice.centner Excel Discussion (Misc queries) 2 May 6th 05 02:00 AM
delete values in several cells without deleting the formulas dranreb Excel Discussion (Misc queries) 4 December 9th 04 01:15 AM


All times are GMT +1. The time now is 06:49 AM.

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"