| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM
Ron,
Beauuuuuuuuuuuuuuutiful! This is exactly what I was looking for. Thanks SJ "Ron Coderre" wrote in message ... Try this: Select your range of "dates" From the Excel main menu: <edit<replace Find what: ~' Replace with: (leave this blank) Click the [Replace All] button Does that help? *********** Regards, Ron XL2002, WinXP "SSJ" wrote: Hello! When I download data into excel some of the dates in the data comes as: 2Sep'06 I edit the cell by taking out the apostrophe and the value becomes a date. What formula / function can I use to take out or clean this apostrophe and make it a date? Thanks SJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
| Mileage Claim Formula | New Users to Excel | |||
| Change the size of text used in a Form combo box | Excel Discussion (Misc queries) | |||
| how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Threaded Mode
