| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a column with a function
I am trying to convert a column of dates that come in the format "20071101"
into "2007-11-01" in an automated fashion (if possible in a formula since I will include it in another one) problem, the data is imported which means that is comes in "general" format and needs to be in either "text" or "number" format for me to use any of the functions like VALUE... how can I change to entire coulmn with a function so that it converts the data to correct format? (without using TEXT TO COLUMS) thx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
| How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
| How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
| Label Format to Column Format | Excel Discussion (Misc queries) | |||
| Format Column with Same Function | Excel Worksheet Functions | |||
Threaded Mode
