| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| problems with RATE function returning #NUM | Excel Worksheet Functions | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| DATA VALIDATION with LEFT function | Excel Discussion (Misc queries) | |||
Linear Mode
