|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 22nd 08, 10:38 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Remove slash charaters from a date field
How do I remove the slash characters from a date field. I have converted all
the date formats to text and need a way to remove the slashes. 
|
| Ads |
|
#2
December 22nd 08, 10:44 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove slash charaters from a date field
> How do I remove the slash characters from a date field. I have
> converted all the date formats to text and need a way to remove the > slashes. One way: =SUBSTITUTE(A1,"/","")
|
|
#3
December 22nd 08, 11:27 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove slash charaters from a date field
Thank you very much
"MyVeryOwnSelf" wrote: > > How do I remove the slash characters from a date field. I have > > converted all the date formats to text and need a way to remove the > > slashes. > > One way: > =SUBSTITUTE(A1,"/","") >
|
|
#4
December 23rd 08, 12:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove slash charaters from a date field
You could have kept the dates in the cells as dates, and used a custom
number format that omits any punctuation. For example, "yyyymmdd" or "mmddyy". This would be more useful if you needed the numeric character of the dates. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "GaryO" > wrote in message news  > How do I remove the slash characters from a date field. I have converted > all > the date formats to text and need a way to remove the slashes.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I remove non-numerical charaters from a string? | Steve | Excel Worksheet Functions | 3 | May 23rd 08 04:30 PM |
| New date based on one date field minus minutes in another field | [email protected] | Excel Discussion (Misc queries) | 1 | December 25th 07 04:05 PM |
| why is slash in my date (10/18/07) the / are change to \? | Dee | New Users to Excel | 4 | November 8th 07 12:48 AM |
| Counting Charaters | Coccoleggs | Excel Worksheet Functions | 8 | September 21st 07 05:06 PM |
| Remove time from a date and time field? Format removes the displa. | oaoboc | Excel Worksheet Functions | 1 | February 16th 05 07:20 PM |
Linear Mode
