| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date not Saving As Expected
I have this code in a VBA module:
Rows(1).Insert Range("A1").Value = "H" Range("B1").Value = SheetName Range("C1").Value = Date Range("C1").NumberFormat = "m/dd/yyyy" Range("C1").NumberFormat = "@" When debugging, it returns the correct date, yet when I view the modified worksheet, this date is displayed as a number, then stored as one. How can I ensure that it is saved in m/dd/yyyy format? I've tried this with and without that last NumberFormat statement with the same result. Kevin -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| saving a file with a date | Excel Worksheet Functions | |||
| Saving with name and date macro | Excel Discussion (Misc queries) | |||
| save as future date eg expected delivery date | Excel Discussion (Misc queries) | |||
| Modify Date Changes when NOT saving | Excel Discussion (Misc queries) | |||
| Saving with date in filename | Excel Programming | |||
![Kdub via OfficeKB.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
