Hi
i think I posted a solution for this

--
Regards
Frank Kabel
Frankfurt, Germany


Thank you, thank you, and many thanks yous!!

My other question was is there a way to format one cell so that it
displays a Canadian Postal code like this:

V9T 9T1

when you enter this: v9t5t1

Notice the capitals and the space in the middle.

Thanks,

John


---
Message posted from http://www.ExcelForum.com/