Hi JE,
That's not working for me. Not working means nothing
happens.
What does work is T to C.
Fixed width
Place the delimiter before the decimal point.
Still have to manually format as desired.
Couldn't come up with a formula solution that's really
much better than what the OP is already doing.
Biff
-----Original Message-----
One way:
Data/Text to Columns. Select Delimited, and click Next.
Check the Space
checkbox and click Finish.
In article <D84AFF1F-CA34-456B-AA06-
,
"Mark Ada" wrote:
From file dump have combined date time cells
eg "14/04/03 14:20" (value
37725.59722). Want to perform time analysis so need to
split to 2 separate
cells; eg. "14/04/2003" (value 37725) & "14:20" (value
0.59722). Is there a
fnc to do this? (Currently convert cell to value, then
fncs trunc & cell
less int(cell) then refmt to date dd/mm/yy & time hh:mm
respectively)
.