View Single Post
  #2 (permalink)  
Old November 29th, 2005, 06:20 AM
ChrisScott ChrisScott is offline
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi David,

Not sure exactly what you are after, but Right("000" & CStr(myNum), 4) would return a string "0004" for the number 4 (and four digit strings for other numbers).

Any help?

Chris