LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,101
Default changing cell contents based on a condition

For all cells in a column, E2 - E20, that contain a value of 0, how can you
change the value to a space while making no changes to cells containg a value
0?

 
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
Pull cell contents from one wksh to another if condition is met Susan Excel Worksheet Functions 3 April 22nd 09 03:41 PM
Formula: copy/concatenate cell contents matching condition Neil Hutchinson Excel Discussion (Misc queries) 4 September 2nd 08 09:51 AM
Changing Length of Cell Contents taylord1936 Excel Discussion (Misc queries) 6 August 20th 08 12:41 AM
Changing cell contents Mike Excel Discussion (Misc queries) 2 February 11th 08 04:41 PM
Changing the Contents of a Cell PaulW Excel Discussion (Misc queries) 0 March 30th 06 10:40 AM


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