Strlength 1

[thewishla]

I have a field which lists serial numbers, at the moment some are 4 digits long, some 5 etc... I would like to know how I can run a query that makes all the numbers 8 digits long please.

Thanks

 

[xlbo]

I'm presuming you're in access as you're referring to a query - you don't need to. Just change the format of the field in the table to 00000000 - whatever values you have in there will get 0's added to the front up to a max of 8 digits.
If you are in excel, use the REPT function
=REPT("0",8-LEN(A1))&A1 where your vlaue is in A1
HTH
Geoff

 

[mikey2nicey]

Hi thewishla,

If you are using VBA then try the following link:

http://msdn.microsoft.com/library/d.../odeopg/html/deconformattingnumericvalues.asp

It gives advice on how to use the VBA Format function to format numeric values.

HTH mikey2nicey
"Dream, but don't quit your day job."

 

[thewishla]

Thanks works just as I need it

 

[xlbo]

Thewishla - you should really say which one worked - and give it a star. I'm not fishing for stars but the protocol on this site is if a post has been helpful / informative, you should give a star. It also helps others see where helpful posts have been made, even if it is not for a question they have asked and denotes useful "locaters" for good information.
Again - please don't think I'm fishing here - If Mikey's post was the one you used, give it a star, esp. as your response was
Thanks works just as I need it
which means it obviously solved your problem
Rgds
Geoff

 

[mikey2nicey]

Hi thewishla,

I'm pleased that your problem has been resolved but xlbo is right in what he says - the post that solved your problem should really get a star.

Cheers, mikey2nicey
"Dream, but don't quit your day job."

 

[rmikesmith]

Geoff & Mikey,

I'm new to these forums also. Thanks for the protocol tip!

Geoff: I've been using Excel for many years and never ran across the REPT function. Amazing! Thanks.

 

[thewishla]

xlbo got the star, I got the solution thanks