Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 30th 09, 09:58 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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?


  #2   Report Post  
Old April 30th 09, 10:21 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 2
Default changing cell contents based on a condition

Mike,

I can't tell you how to eliminate the value, but you could conditionally
format the cells that contain a value = to or less than 0 to white text-
which might accomplish what you need... if your main goal is to not see the
0...


"Mike" wrote in message
news
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?



  #3   Report Post  
Old April 30th 09, 10:26 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 209
Default changing cell contents based on a condition

Mike wrote:
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?


Find and replace? Select the cells find 0 change to blank

gls858
  #4   Report Post  
Old May 1st 09, 12:54 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default changing cell contents based on a condition

What is your aim?

To not see the zeros?

Do not replace with a space. That will cause you problems down the line.


Gord Dibben MS Excel MVP

On Thu, 30 Apr 2009 13:58:37 -0700, Mike
wrote:

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?


  #5   Report Post  
Old May 1st 09, 02:05 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,101
Default changing cell contents based on a condition

Thanks for the response, but for what I'm doing, I need a space in the field
if the preceding fields are blank. I can "find and replace", but I wanted
something automatic.

"Whitney Serio" wrote:

Mike,

I can't tell you how to eliminate the value, but you could conditionally
format the cells that contain a value = to or less than 0 to white text-
which might accomplish what you need... if your main goal is to not see the
0...


"Mike" wrote in message
news
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?






  #6   Report Post  
Old May 1st 09, 02:08 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,101
Default changing cell contents based on a condition

Thanks for the suggestion. I was trying to avoid doing this. I have 115,000
records in 6 spreadsheets and they we have to be recreated on a regular basis.

"gls858" wrote:

Mike wrote:
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?


Find and replace? Select the cells find 0 change to blank

gls858

  #7   Report Post  
Old May 1st 09, 02:10 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,101
Default changing cell contents based on a condition

Approx. 115,000 records are being exported from a new software system. I'm
creating 6 smaller files from the large file based on the district they are
from. I'm then creating a spreadsheet for each file. Each line of the
spreadsheet will have an ID value in column A. Each line will have values in
either columns B,C,&D or E,F,"&G. If B&C or E&F are blank, I cannot have a 0
in D or G, which is happening now. When the spreadsheets are finished they
will be saved as a DBF file and the information will be used on a web site.
Random 0's are not acceptable. I can find and replace, but I would prefer to
use an embedded function.

"Gord Dibben" wrote:

What is your aim?

To not see the zeros?

Do not replace with a space. That will cause you problems down the line.


Gord Dibben MS Excel MVP

On Thu, 30 Apr 2009 13:58:37 -0700, Mike
wrote:

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?





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
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 11:28 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017