| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format from numbers to a real date?
I have two colunns,
column A has a real date i.e. 12/31/08 column B has test i.e. Calendar Year I want column C to read in one line "12/31/08: Calendar Year" So I entered the following formula in column C: =A1 & ": " & A2 It works but it looks like this - - - "38717: Calendar Year" ??? I want to then copy/paste special so that I have this actual info to upload into another program. How do I format column C so that I get the 12/31/08 to appear in the results? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying date as a real number | Excel Discussion (Misc queries) | |||
| date in text format as a real date | Excel Worksheet Functions | |||
| Converting Numbers to Date Format | Excel Worksheet Functions | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
| real date for column | New Users to Excel | |||
Threaded Mode
