Hi All.
In a previous version of a spreadsheet I created, when a value was placed in 'B5' .. C5 would then populate with an automatic 'NOW'.
However, I didn't know at the time, procuded the cell to read not only the date, but also a time. 17 Jul 06 12:38:45
I have since change the auto code to DATE instead of NOW, but was wondering if there was anyway to changed the already populated cells so that it did not show the time without having to manually enter it again.
HELP!!