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: 17
Default empty display in place of 0.0 ... possible?

Someone here was kind enough to provide a formula which converts kg in one
column to lbs in another.

Is it possible where there is no kg value, that the lb value instead of
displaying 0.0, displays an empty cell?

Thanks, Dave Horne Excel 2007

 
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
empty links display Allison Excel Discussion (Misc queries) 1 May 4th 07 04:38 PM
Display empty cells botany_girl Excel Discussion (Misc queries) 7 July 19th 05 06:40 PM
Display empty cells botany_girl Excel Discussion (Misc queries) 1 July 19th 05 05:51 PM
place empty cell with zero prince Excel Worksheet Functions 3 April 20th 05 05:55 PM
How do I set a cell to "Empty" so that it does not display in a ch Ian Charts and Charting in Excel 3 January 7th 05 01:12 AM


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