Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have this date and time value (Friday, October 15, 2004 10:35:12) stored in a cell ("E80"). I need to format it to 10/15/04 and paste it in another spreadsheet. What is doing right now is changing to today's day.... I just need the date, ignore the time. I've tried Format(Date, "mm/dd/yy") and this is the one giving me todays date... Help... this formatting date is not making my date ... -- gaba :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
Formatting Date | Excel Discussion (Misc queries) | |||
XML date formatting | Excel Worksheet Functions | |||
date formatting | Excel Discussion (Misc queries) | |||
Date Colum Date Formatting & Validation | Excel Programming |