| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to calculate time
That didn't do it. I used the code:
Sub test() Range("b1") = Range("a1").Value With Range("b1") ..NumberFormat = "MMMM DD, YYYY" End With but when I changed the format of the cell to text, I see: 38646 How can I convert the date to the above format, then copy the results, *as text*, to another cell, formatted as text? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How calculate end time with beginning time plus formula minutes | Excel Worksheet Functions | |||
| Formula Calculate after a certain time of day. | Excel Discussion (Misc queries) | |||
| Formula to calculate over-time | Excel Discussion (Misc queries) | |||
| Formula to calculate time | Excel Discussion (Misc queries) | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Threaded Mode
