View Single Post
 
Old 02-13-2019, 05:41 PM
eduzs eduzs is offline Windows 10 Office 2010 32bit
Expert
 
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
__________________
Backup your original file before doing any modification.
Reply With Quote