workbook excel 2010
=TRIM(SUBSTITUTE('Main Form'!C14," ",""))
I'm grabbing dates from sheet Main Form.
to sheet 2 with the formula above but the cells are displaying 29222 ?
Anyway to correct the formula to correctly display on Main Form
cells are formatted like date: 01/01/80