=Format(string format, {object arguments}, ...) : string    

Concatenating strings in Excel is a bitch. Enter .Net formatting:

Format is really useful for building SQL statements:

You can supply Format with multiple vectors:

Fully supports .Net composite formatting (string.Format).

=Format("{0:0.00}",123.4567) => "123.46"
=Format("{0:0000}",3) => "0003"

Syntax reference:

Note that Date formatting doesn’t work because Excel treats dates as numbers.

Get help with this function in the community →