| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Dashes within aText String
Insert a column next to the data with A1 being the cell with the unformatted
data... enter this formula... =CONCATENATE(LEFT(A1,4),"-",MID(A1,5,2),"-",RIGHT(A1,2)) -- then select the formula column and copy, then paste as values... then delete the unformatted column ~Christine, CPA "Ron Rosenfeld" wrote: On Thu, 22 Jun 2006 03:28:01 -0700, RC wrote: I have a column of cells within Excel with different values, an example of the text is like 20060602. I want them to be in the format 2006-06-02. Can you suggest a formula to use =TEXT(A3,"0000-00-00") However, what do you want to do with the result? This will not be interpreted as a date by Excel. --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displays the number in text. (One thousand two hundred thirty four | Excel Worksheet Functions | |||
| Property Let: assign return value of Double when passing String | Excel Discussion (Misc queries) | |||
| Browse File for Mac | Excel Discussion (Misc queries) | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
| How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Threaded Mode
