Thread: IBAN Number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default IBAN Number

On Thu, 23 Sep 2010 17:23:00 +0200, "Charlotte E" wrote:

Is is possible to create an UDF, which validates an IBAN number accoring to
this:

http://en.wikipedia.org/wiki/Interna...ing_the_I BAN

TIA,


Actually, the valid two letter country codes can be deduced from the IBAN
fields listed in the article you cite, so it should be relatively simple for
you to set up a lookup table.
--ron