LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Connie
 
Posts: n/a
Default How do I not display the Euros sign, if value is 0?

I have spread sheet that has many lines that converts dollars to Euros, but
if dollars are not input on a line, I would like the cell to be blank and not
the the Euro sign and a dash. Anybody have an answer?
 
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
how to display subjects taught by a specific teacher upon selection of the teacher name in a drop down box janice fernandes New Users to Excel 5 March 9th 06 12:24 PM
Formatting: Display a minus sign before a number SharonJo Excel Discussion (Misc queries) 8 January 7th 06 03:37 AM
display plus sign on plus numbers in Excel tnoble Excel Discussion (Misc queries) 1 November 19th 05 02:28 PM
I want to display the minus sign ED New Users to Excel 7 October 27th 05 10:06 PM
Combine & Display “Fixed” & “Automatically Updated” Date Parts texcel Excel Worksheet Functions 1 November 1st 04 05:38 PM


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