you don't need to write a new function for this vb already have a function name called Format(value,"Form ...
www.dreamincode.net