Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
Im trying to populate a cell with a date which is created by concatenating Day & Month & Year values in a format "dd/mm/yyyy". It is then assigned to the cell also formatted as 'dd/mm/yyyy'. However the actual result(displayed in the cell) is still "mm/dd/yyyy". How could this happen and how should it get rectified? Thanks in advance and regards Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stubborn cell formatting. | Excel Worksheet Functions | |||
A Very stubborn apostrophe that only shows in editing mode and the formula bar... | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
stubborn macro | Excel Programming | |||
Stubborn Link Data/Value Problem - Help Appreciated! | Excel Programming |