• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

how will be VB Script code to adding prefix zero that the Dept number will be consist from 5 digits, if less then 5 digits will adding zero's at the beginning?

thanks
Gvilbis
0
gvilbis
Asked:
gvilbis
1 Solution
 
Chris BottomleySoftware Quality Lead EngineerCommented:
Something like:

right("00000" &  yourNum, 5)

where yournum is ...

Chris
0
 
gvilbisAuthor Commented:
perfect, thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now