LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edellav
 
Posts: n/a
Default How do I enter a blank, not "", into a cell with a conditional for

Sort sequence rules place blank cells at the end of both ascending and
descending sorts which is what I want. However, cells that contain "" are
sorted before numbers in descending sorts, which I don't want. I create a
conditional formula to test for division by a cell that is blank, if true, I
want the result to be a true blank cell, not a cell with "". Is there a
special character code or function that I can use to accomplish this? I'm
using Excel 2002.
 
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
enhanced conditional formatting Stuart Excel Discussion (Misc queries) 13 November 13th 05 07:20 PM
Conditional Format to highlight blank cell DaveMoore Excel Worksheet Functions 4 June 23rd 05 10:10 AM
blank cell turns to 0 LMB New Users to Excel 2 April 25th 05 03:57 PM
Look for change next blank cell in Range Nigel Bennett Excel Worksheet Functions 1 March 13th 05 09:45 PM
conditional formatting blank cell TREK5200 Excel Discussion (Misc queries) 1 December 6th 04 02:23 AM


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