| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Date Format Questions
how do I get this
=((DATE(2005,12,30))&" YTD") to look like this Dec 05 YTD Right now I have a Cell that look like : 38716 YTD |
|
#2
|
|||
|
|||
|
Hi
=TEXT(DATE(2005,12,30),"mmm dd")&" YTD" Arvi Laanemets "Mestrella31" wrote in message ... how do I get this =((DATE(2005,12,30))&" YTD") to look like this Dec 05 YTD Right now I have a Cell that look like : 38716 YTD |
|
#3
|
|||
|
|||
|
or you could just format the cell as mmm dd \YT\D
-- HTH RP (remove nothere from the email address if mailing direct) "Arvi Laanemets" wrote in message ... Hi =TEXT(DATE(2005,12,30),"mmm dd")&" YTD" Arvi Laanemets "Mestrella31" wrote in message ... how do I get this =((DATE(2005,12,30))&" YTD") to look like this Dec 05 YTD Right now I have a Cell that look like : 38716 YTD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
| prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
Hybrid Mode
