View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jamescox[_2_] jamescox[_2_] is offline
external usenet poster
 
Posts: 1
Default Need help with format number


Take a look at your post - you may be using a character set that this
site can't handle - something is causing some of the characters you are
using to be runreadable as rendered.

At any rate, I don't think number formatting can deal with what you
want to do - but I could be wrong.

If this is for display to the user, you might be able use an If
statement to detect the presence of whatever you are looking for and
return the appropriate value.

Good luck on this!


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111533