FORMAT number

User avatar
sal21
PlatinumLounger
Posts: 4343
Joined: 26 Apr 2010, 17:36

FORMAT number

Post by sal21 »

i have:

myvar="13.77"
myvar="48.145"

i need to format in this mode:

13.7700
48.1450

note:
myvar as String
Top
User avatar
HansV
Administrator
Posts: 78391
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: FORMAT number

Post by HansV »

Code: Select all

    myvar = Format(myvar, "0.0000")
Best wishes,
Hans
Top

Return to “VB/VBA/.Net/Office Scripting”