Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Newbie

Status
Not open for further replies.
as123

as123

IS-IT--Management
Mar 7, 2003
1
0
0
CA
I want to add 3 leading spaces to a output which is a number.

I have a function which returns numeric values as output.
say for example the output values are 1, 1000, 1200,2,23.
I would like to format this as follows.
1
1000
1200
2
23

Is there a way to do this.
All help is highly appreciated.

Thank you in advance.
Arvind.
 
Sort by date Sort by votes
Code: 
If x < 10 Then 'assuming positive # only
  x = &quot;   &quot; & x '3 spaces
ElseIf x < 100 Then
  x = &quot;  &quot; & x '2 spaces
ElseIf x < 1000 Then
  x = &quot; &quot; & x '1 space
End If
. . .
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Mauro_
  • Locked
  • Question
-Newbie- Renaming folders and subfolders with files count
Replies
1
Views
35
markdmac
markdmac
klojo80
  • Locked
  • Question
Newbie trying something in VBS
Replies
2
Views
25
klojo80
klojo80
Appok
  • Locked
  • Question
VBS Newbie 2
2
Replies
30
Views
45
Appok
Appok
sirnose1
  • Locked
  • Question
Newbie has issue with Generics
Replies
0
Views
7
sirnose1
sirnose1
1ncubu5
  • Locked
  • Question
VBS/WMI Newbie, help needed...nearly working 1
Replies
2
Views
20
1ncubu5
1ncubu5

Part and Inventory Search

Sponsor

Back
Top