Format Function In VBA

[snb]

@Rick

x3 = Format$(1234)

results in the same kind of variable as Format(1234) (see the locals window).

[Rick Rothstein]

@Rick

x3 = Format$(1234)

results in the same kind of variable as Format(1234) (see the locals window).

Wow, either Google has gotten worse at finding stuff, or Microsoft pulled most of the non-VB.NET documentation, but it used to be much easier to find online documentation about the difference between VB/VBA functions with and without the $ sign. I did locate this from Microsoft's Office 2000 documentation, however...

http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

...see the second paragraph (starts with the word Note in bold letters).