| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Help
G'day Keith
I'm assuming your importing as PasteSpecial.Value. Which means it pastes the actual Time.Value, which in this case is 36892. Highlight the entire column in question. Goto: FormatCell | Number | Custom Enter: mm-dd-yy or if you prefer dd-mm-yy HTH Mark. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
