Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date format within a text syntex?
I have two date fields that users enter dates into.
I have a field with the following formula where I want the dates to appear within a preformatted sentence: ="FOR THE PLAN YEAR " & 'ENTER DATA'!B13 & " THROUGH " & 'ENTER DATA'!B15 The forula works but the dates are resulting in numbers or date values. I would prefer to see the dates (i.e. 01/04/05) Can excel do that? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
TEXT function to format a date in English & French | Excel Worksheet Functions | |||
Date format collapses diagram | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
How to write a "Text" or date custom format | Excel Worksheet Functions |