| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
The left function does not work when displaying times, how is thi.
The left function does not work when displaying times on Excel 2000. I
entered the data in the following format "9:40," but the data box converts it to "9:40.00 AM." I changed the format so the time appears as "9:40" on the spreadsheet. However, I want to display just the hour, the first digit, in the next column. When I use the left function (=LEFT(B4, 1)), I always get a zero. Just to see what happened, I displayed the left 4 digits and I receive some unusual fractions "0.402..." I would greatly appreciate some help on this topic. 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 | |||
| How do I protect work sheet against the "Delete" function? | Excel Discussion (Misc queries) | |||
| Concatenate Function will not work | Excel Discussion (Misc queries) | |||
| Displaying value of specific cell within a range, with IF function...? | Excel Discussion (Misc queries) | |||
| left worksheet function within a combo box | Excel Worksheet Functions | |||
Threaded Mode
