View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Michael G. Thomas Michael G. Thomas is offline
external usenet poster
 
Posts: 2
Default Using VBA to remove leading zeros

Yes, the data is alphanumeric unfortunately. I have the code already
though, all I need to know is how to use it. In Access, you can create a
module and then call the module using a query. Is there something similar
in Excel? Just wanna know where to put the code and how to run it.

Thanks,
Michael


On Sun, 12 Sep 2004 10:16:18 -0400, Tom Ogilvy wrote:

Nick's version will work if the data is all numeric (not alpha
numeric). Is
that the case?




--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/