Hello. I'm having problems with the LEFT function of Microsoft Excel. I'm
trying to have cell B1 display the date in A1 (but not the time). In cell B1
the formula is
=LEFT(A1,10), and this displays 38623.6205. I do not understand why this
happens, because when I have used the same formula in a different database it
comes up with just the date.

A1 B1
28/09/2005 14:53:36 38623.6205

Any help would be really appreciated. Thanks