You're welcome. Thanks for feeding back.

Pete

richardwo wrote:
Works perfectly. Thanks very much Pete_UK

"Pete_UK" wrote:

Use INT(A1) rather than the LEFT function and format the cell as a Date
with a display that suits you.

Hope this helps.

Pete

richardwo wrote:
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