| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Date
I have a column that contains dates in this format mm/dd/yyyy. I need
mmddyyyy no slashs. If I do a custom format it still shows mm/dd/yyyy in the the fx bar. I have tried using vbscipt replace method and copy the new date to a different column but it drops the zeros no matter what the columns format is. I need to create passwords from this column and I have to take out the slashes. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formatting help | Excel Discussion (Misc queries) | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Can a date be used for conditional formatting? | Excel Worksheet Functions | |||
| Conditional Formatting, date. | Excel Worksheet Functions | |||
| Despite formatting a column in Excel 2002 worksheet as Short Date. | Excel Discussion (Misc queries) | |||
Threaded Mode
