| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
displaying yy instead of yyyy
Hi Norman,
Thanks for saving my day. Joshua "Norman Jones" wrote: Hi Joshua, The following worked for me for a specified range. Sub XYZ() Dim rng As Range Set rng = Range("A1:A10") With rng .NumberFormat = "dd-mm-yyyy" .Cells(1).Value = "01-Jun-2005." End With End Sub I am not aware of a way to change the default behavior. --- Regards, Norman "josh7" wrote in message ... I have used the statement Format(sysdate,"dd-mm-yyyy) in Visual basic 6.But as soon as it gets entered in Excel its truncates the date to dd-mm-yy. Is there a way to automate this process using Visual Basic 6 to dd-mm-yyyy Thanks, Joshua "Norman Jones" wrote: Hi Josh7, Format the date entry cells with a custom format: dd-mmm-yyyy --- Regards, Norman "josh7" wrote in message ... When I enter a date value in excel spreadsheet like 01-Jun-2005 ,its saving the value as 01-Jun-05 instead of 01-Jun-2005.What should I do to save it as 01-Jun-2005. Thanks, Joshua |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a birthdate format from yyyy/mm/dd to mm/dd/yyyy | Excel Worksheet Functions | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
| change birthday display from mm/dd/yyyy to HIDE the yyyy? | Excel Worksheet Functions | |||
| YYYY format displaying wrong date | Excel Discussion (Misc queries) | |||
| opening excel file - date format problem: DD/MM/YYYY vs MM/DD/YYYY | Excel Programming | |||
Threaded Mode
