Thank for your help. I first think to use If, but how can detect the euro
format?

"jamescox" wrote:


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