Ok hi guys / gals,
I have a time macro using =now() and i have the cells formated to show either the date or time. But the issue I have is I only want the date or the time entered instead of both. I need it to only have the date in the cell because im using it as a reference point and it doesnt work with the time in the cell also.
Currently-
Cell shows 3/30/09
Entered in cell 3/30/09 12:00:00 pm
Needing-
Cell shows 3/30/09
Entered in cell 3/30/09
Any ideas?
I have a time macro using =now() and i have the cells formated to show either the date or time. But the issue I have is I only want the date or the time entered instead of both. I need it to only have the date in the cell because im using it as a reference point and it doesnt work with the time in the cell also.
Currently-
Cell shows 3/30/09
Entered in cell 3/30/09 12:00:00 pm
Needing-
Cell shows 3/30/09
Entered in cell 3/30/09
Any ideas?