Excel 2016 2013 2010 2003

Combining text and formatted values

The Excel TEXT function enables you to specify numbers and date format.