| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
concatenate text and date
when I concatenate a text field & " "&date field it's displaying the text
fine but displaying the date in serial number e.g. location and date 01/01/2001 becomes location and 19283 How can I maintain the date format? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
| EXTRACT TEXT FROM A DATE | Excel Worksheet Functions | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| Advanced Filter using Date represented as text | Excel Worksheet Functions | |||
| & reference answering as Date Serial # not actual text | Excel Worksheet Functions | |||
Threaded Mode
