Microsoft Office Forums - View Single Post - VBA format function

Thread: VBA format function

View Single Post

Old

02-13-2019, 05:41 PM

eduzs

eduzs is offline

eduzs uses Windows 10

Windows 10 eduzs uses Office 2010 32bit

eduzs uses Office 2010 32bit

Office 2010 32bit

Expert

The original poster

Join Date: May 2017

Posts: 266

eduzs is on a distinguished road

Default

VBA format function

Hi,
I need to use vba FORMAT function to return this:
Result = Format(MyNumber,"x")
MyNumer Result
123 123

1234 1.234
1234,1 1.234,1
1234,12 1.234,12
What "x" will produce these results?
Thanks

Reply With Quote