Problems with LEFT Function

R

richardwo

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
 
P

Pete_UK

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
 
R

richardwo

Works perfectly. Thanks very much Pete_UK

Pete_UK said:
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
Click to expand...
 
Top