| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
input date format "ddmmyyyy"
I'd like to input my date as "ddmmyyyy" . For example, if i input 12032008, i
should have 12/ March/2008. However, my current setting turns out to be 3/Dec/2008. it's totally up-side down. Dear experts, thanks a lot ! -- Allen Phailat Wongakanit |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Date Format" v.s. "##/##/####" | Excel Worksheet Functions | |||
| When I input "25:03" as a time, it reads "1:03" | Excel Discussion (Misc queries) | |||
| need help with a conditional format in regards to "date" input | Excel Discussion (Misc queries) | |||
| Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
| How do make input date by "month/day" in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
