| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Date to STring
On Wed, 15 Feb 2006 00:40:36 -0600, tonymaguire
wrote: How do I convert a date (25/11/2005) in a date field to the same string in a General or Text field? Whenever I try Excel converts to the serial value of the date. You use the TEXT worksheet function. eg: =TEXT(A1,"YYYYMMDD") --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Date / Currency Convert | Excel Discussion (Misc queries) | |||
| Need help: convert seconds to date and time | Excel Discussion (Misc queries) | |||
| convert Julian date | Excel Worksheet Functions | |||
| How to convert string to a date | Excel Worksheet Functions | |||
| How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
Threaded Mode
