Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Posting
In a new WB - Book1 - in the immediate window I type in:
x = now ? x 11/18/2007 10:25:29 AM x =Format(x,"mmmm dd, yyyy") ? x November 18, 2007 Range("A1") = x =================================== Why does A1 display 18-Nov-07 (formula bar = 11/18/2007) ?? TIA, Jim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Posting
If you want to treat that cell like text, you could use:
Range("A1") = "'" & Format(date,"mmmm dd, yyyy") or with range("a1") .numberformat = "@" 'text .value = Format(Date,"mmmm dd, yyyy") end with if you want to treat that cell as a date: with range("a1") .numberformat = "mmmm dd, yyyy" .value = date end with Jim May wrote: In a new WB - Book1 - in the immediate window I type in: x = now ? x 11/18/2007 10:25:29 AM x =Format(x,"mmmm dd, yyyy") ? x November 18, 2007 Range("A1") = x =================================== Why does A1 display 18-Nov-07 (formula bar = 11/18/2007) ?? TIA, Jim -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Posting problems...again! | Excel Discussion (Misc queries) | |||
[OT] posting | Excel Worksheet Functions | |||
Posting date | Excel Worksheet Functions | |||
the owner of posting should be able to delete the posting | Excel Discussion (Misc queries) | |||
Posting in the next row | Excel Worksheet Functions |