| 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 |
| 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) | |||
Threaded Mode
