A
Andy
Two queries:
1. have a cell in format of dd/mm/yyyyy hh:ss. Need to dump into a new cell,
just the dd/mm/yyyy portion so that I can perform further calculations.
Everything I try displays just the dd/mm/yyyy data, but when the cell is
seleced, the hh:mm is still there.
2. Same situation when using the month function on a date. The function
output cell does indeed display the month, but the actual data in the cell is
still the date.
Have tried trimming, pasting values only and a whole bunch of other issues.
HELP!!!!
1. have a cell in format of dd/mm/yyyyy hh:ss. Need to dump into a new cell,
just the dd/mm/yyyy portion so that I can perform further calculations.
Everything I try displays just the dd/mm/yyyy data, but when the cell is
seleced, the hh:mm is still there.
2. Same situation when using the month function on a date. The function
output cell does indeed display the month, but the actual data in the cell is
still the date.
Have tried trimming, pasting values only and a whole bunch of other issues.
HELP!!!!