LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
Posts: 408
Default i need to convert blank spaces into zero values

I am uploading values from an existing data base. Sometimes there is no items
sold during the time so it just gives me a blank area. I need to change that
to a zero so it will calculate correctly. I have tried @if statements but am
getting no results sinve the area is blank to begin with. All i need is a
statement that says if the area is blank result =0, or the number that is
there.

Thanks for any help.
 
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
Expression for Blank Spaces dsears Charts and Charting in Excel 2 January 30th 07 04:52 AM
ranking with some blank spaces LRR via OfficeKB.com Excel Worksheet Functions 7 April 16th 06 03:04 PM
Blank Spaces on Sort Xiazer Excel Discussion (Misc queries) 0 February 28th 06 09:56 AM
Blank spaces Scurloc Excel Discussion (Misc queries) 4 December 22nd 05 05:08 PM
Blank spaces in a listbox Soundman Excel Discussion (Misc queries) 3 August 17th 05 02:13 PM


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

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"