| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can excel convert a date to text
If in cell B3 i have a date in this format: 6/27/2008. Is there anyway that I
could put a formula in a cell F2 that makes my output read 62708 or 6272008? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can excel convert a date to text
=YEAR(B3)+DAY(B3)*10000+MONTH(B3)*1000000 and format as general
-- Gary''s Student - gsnu200793 "Hamed parhizkar" wrote: If in cell B3 i have a date in this format: 6/27/2008. Is there anyway that I could put a formula in a cell F2 that makes my output read 62708 or 6272008? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can excel convert a date to text
=TEXT(A1,"MDDYY")
or =TEXT(A1,"MDDYYYY") "Hamed parhizkar" wrote: If in cell B3 i have a date in this format: 6/27/2008. Is there anyway that I could put a formula in a cell F2 that makes my output read 62708 or 6272008? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - convert dates to text but appear as a date format | Excel Discussion (Misc queries) | |||
| VBA convert day and date from text string to Excel date | Excel Programming | |||
| Excel, how do I write a macro to convert the date value to text? | Excel Programming | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
| Set Excel to not automatically convert text to date | Excel Programming | |||
Linear Mode
