| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with custom date formats
Hi
I'm programmatically populating a column with dates of the format "yyyymmdd". I'm setting the NumberFormat for the Column to "yyyymmdd". All values which are being used are being displayed (eg 20000224) as ######################### How get I get Excel to display the date "as is" whilst maintaining the date data-type for the column. Thanks Simon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem custom sorting a date in an excel file | Excel Discussion (Misc queries) | |||
| Date custom formats | Excel Discussion (Misc queries) | |||
| importing csv files, problem with date formats | Excel Worksheet Functions | |||
| I need a macro to convert my date formats into a custom layout. | Excel Programming | |||
| I need a macro to convert my date formats into a custom layout. | Excel Programming | |||
![Simon Woods[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
