| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format changing on edit replace
In code you can split the date with Dim YearStr, MonthStr, DayStr as string YearStr = Format(... , "yyyy") MonthStr = Month(... , "mm") DayStr = Day(... , "dd") DateStr = DayStr & "/" & MonthStr & "/" & YearStr -- Kaak ------------------------------------------------------------------------ Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513 View this thread: http://www.excelforum.com/showthread...hreadid=377644 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I edit the formula without changing the format? {=SUM(if. | Excel Worksheet Functions | |||
| find and replace for date format | Excel Discussion (Misc queries) | |||
| cell format changing when when using search and replace. | Excel Discussion (Misc queries) | |||
| cell format changing when when using search and replace. | Excel Discussion (Misc queries) | |||
| how do i replace ( with / without changing format to fraction | Excel Worksheet Functions | |||
![Kaak[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
