- Dec 5, 2009
Is there any way to format a cell so that it not only shows a date as mm/dd/yyyy in the cell, but also contains the value as mm/dd/yyyy? I have some formulas set up to pull the mm, the dd, and the yyyy and concatenate them together, but when the month or day is only a single digit, the =LEFT() and =MID() formulas pull in "1/" and "/2" respectively... I need them to pull "01" and "02" instead. Any ideas?