| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Text to Numbers for Dates
I'm currently working with a column of dates. Some of the dates are text and
some are numbers. The dates are in the following format 21/06/210 (mm/dd/yyyy). I used =isnumber() to verify cells. Half of the coulmn resulted in false values. I'm unable to format the dates to other formats, since some are text. Is there anyway to change the column so that all dates are numbers vs. text, thus allowing me to format them to other date formats??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Text to Numbers for Dates | Excel Discussion (Misc queries) | |||
| Formatting dates with =TEXT() | Excel Discussion (Misc queries) | |||
| Converting Text Dates to Serial Numbers | Excel Worksheet Functions | |||
| Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
| VBA to concatenate Text and/or Numbers and/or dates etc | Excel Discussion (Misc queries) | |||
Hybrid Mode
