James

Your original post required a cell to be split showing the date and time. My
post attempted to address that issue. Are you now saying there are further
requirements? If so, please post them.

--
XL2002
Regards

William



"James Cox" wrote in message
...
| William -
|
| That looked like it had promise, but I don't get the option to set the
cell
| contents - just to format what's already there.
|
| Also, a check on what Excel thinks is in the cell - using the following in
| the VBA editor's Immediate pane
|
| ?isdate(range("a1").Value)
|
| gives a value of "False" so it's no longer a date that Excel can use...
|
| Thanks for giving it a shot!
|
| James
|
|
| "William" wrote in message
| ...
| Hi James
|
| Sub DateAndTime()
| Range("A1") = Format(Now, "dd mmm yy") & _
| Chr(10) & Format(Now, "hh mm ss")
| End Sub
|
|
| --
| XL2002
| Regards
|
| William
|
|
|
| "James Cox" wrote in message
| ...
| | Dontcha just love users? : )
| |
| | I've got one that wants to display Excel dates in
| |
| | 03-Jul-04 09:14:22
| |
| | format, but wants the date and time "stacked" in a single cell, as in
| |
| | 03-Jul-04
| | 09:14:22
| |
| | doing a date-to-text conversion and then using line wrap formatting on
| the
| | cell would "work" - EXCEPT that the date has to stay an Excel date,
not
| a
| | text string.
| |
| | Given Excel's "feature" of displaying dates as ######'s if the cell is
| not
| | wide enough, I can't get any leverage on a way to do what he wants. I
| had
| | thought that the ability to embed text into date (and number formats)
| might
| | be a way to do this, but I can't find a way to get an active CR-LF
| between
| | the halves of the datetime.
| |
| | Anyone have any additional ideas on how to do this?
| |
| | James
| |
| |
|
|
|
|