Problems with LEFT Function
 

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

Problems with LEFT Function
 

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

Problems with LEFT Function
 

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

Problems with LEFT Function
 

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