losing date format when referencing date cell on another sheet
I should have added that you can also use the number format and simply create
your own custom format and that way the cell remains as a date instead of
text.
Use this custom format (dd/mm/yyyy)
Your formula would then be =Sheet1!B15
--
Regards,
OssieMac
|