| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing a Date into a Value
If the date is entered as value, custom it in the number format as YYYYMMNN.
Confused_in_Houston wrote: I have cells that contain dates in the format 2008-04-07. I want to convert that to 20080407. I've tried RIGHT and MID functions but it works with the integer that underlies the date. I've cut the date and pasted it as a value but it again reverts to the underlying integer. How can I convert a date like 2008-04-07 to a value 20080407? Thanks... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date from changing | Excel Discussion (Misc queries) | |||
| Changing date and time to date only | Excel Worksheet Functions | |||
| Cell contents changing to date and not date | Excel Worksheet Functions | |||
| Changing date from =NOW() to Creation Date | Excel Worksheet Functions | |||
| When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions | |||
Hybrid Mode
