Add Excel Format To Range

If this is ticked, when a range is added, Excelerator will automatically set an Excel format for the range.

Dates

The range will be formatted to dd/mm/yyyy

Numbers

The range will be formatted to number, two decimal places

All other types will be formatted to Text.