| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATE FORMAT issue
I have a piece of code like this:
Now() which returns the correct value of 2006/02/08 08:18:41 (with my last test) now if I run the following: Format(Now, "mmm") that brings Jan any ideas why? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DATE FORMAT issue
never mind...solved it...the Month() was throwing it off
Format(now,"mmm") works fine... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
| Another Date issue. | Excel Worksheet Functions | |||
| format date in excel | Excel Discussion (Misc queries) | |||
| Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Linear Mode
