| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I format dates accessed by a formula
How do I format dates accessed by a formula that are included in a text
formula? I use excel 2002. cell a1 has ="as of "&A2 cell a2 currently displays December 30, 2004 Results show as of 38351 instead of as of December 30, 2004 . Any help would be appreciated. Thanks. Mont22 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i create a formula or format the cells so the answer is a. | Excel Discussion (Misc queries) | |||
| formula based on format | Excel Discussion (Misc queries) | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
| How do I format a character from a result of formula in excel? | Excel Discussion (Misc queries) | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
Threaded Mode
