PC Review


Reply
Thread Tools Rate Thread

how to display zero as dashes in worksheet

 
 
hbee
Guest
Posts: n/a
 
      6th Dec 2007
how to display zero as dashes in worksheet?
 
Reply With Quote
 
 
 
 
JE McGimpsey
Guest
Posts: n/a
 
      6th Dec 2007
One way:

Format/Cell/Number/Custom: General;General;"-";@

In article <40D51C57-71D3-4CDB-B57B-(E-Mail Removed)>,
hbee <(E-Mail Removed)> wrote:

> how to display zero as dashes in worksheet?

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      6th Dec 2007
Format>Cells>Number>Accounting with Symbol set to "none".


Gord Dibben MS Excel MVP

On Thu, 6 Dec 2007 09:34:02 -0800, hbee <(E-Mail Removed)> wrote:

>how to display zero as dashes in worksheet?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scan data on worksheet 2 and display a summary on Worksheet 1 =?Utf-8?B?U29ueQ==?= Microsoft Excel Programming 0 29th Jan 2007 08:27 PM
Re: how get telephone number entry to display with spaces or dashes Brian Tillman Microsoft Outlook Contacts 0 8th Jan 2007 06:58 PM
Hyphen, n-dashes, m-dashes Raymond O'Neill Microsoft Word New Users 4 4th May 2005 10:41 PM
Displaying zeros as dashes on a worksheet eschneider71@hotmail.com Microsoft Excel Programming 3 12th Apr 2005 10:11 PM
A cell copied onto one worksheet from another worksheet does display same formatting. =?Utf-8?B?TWFyaw==?= Microsoft Excel Misc 3 5th Jan 2004 04:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:17 AM.