98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » exce+training - How do I convert dates from 12.12.07 to 12/12/07? | Excel forum
exce+training - How do I convert dates from 12.12.07 to 12/12/07? | Excel forum
Resolved · Low Priority · Version Standard
Tue 4 Dec 2007, 12:06Trainer Sandy said...
How do I convert dates from 12.12.07 to 12/12/07?
How do I convert dates which have been typed into a worksheet 12.12.07 to 12/12/07?
Tue 4 Dec 2007, 12:08Trainer Sandy said...
RE: How do I convert dates from 12.12.07 to 12/12/07?
When you type dates in the format of 12.12.2007 in a cell Excel sees this is text. Dates should always be typed in as 12/12/07. To change this format quickly:
1. Select cells to be converted e.g. A6:A26
2. Edit menu, Replace
3. Find What: .
4. Replace with: /
5. Choose Search by Columns
6. Click Replace All
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcut fill a cell with contents from adjacent cellsUse Control + D to fill a cell with the data from an adjacent cell. This speeds up data entry and is a cool tip to share! |
