How do I convert a date format from dd.mm.yy to dd/mm/yy?

Any help appreciated

"Celtic Warrior" wrote:


How do I convert a date format from dd.mm.yy to dd/mm/yy?

Any help appreciated

Highlight the cell/cells you want to format. Then click
Format/Cells/Number/Date and choose the type you want displayed.

Select the cell(s) and Format Cells... Number Custom dd/mm/yy
--
Gary''s Student - gsnu200828


"Celtic Warrior" wrote:


How do I convert a date format from dd.mm.yy to dd/mm/yy?

Any help appreciated

You'll first have to use the replace function in Excel to change the dots "."
to "/"
then format the the cells as mentioned previously. The replace function can
be found under the Edit menu or use the shortcut Ctrl H. Highlight only the
cells that have the dd.mm.yy otherwise all the "." will change to "/".

"Gary''s Student" wrote:

Select the cell(s) and Format Cells... Number Custom dd/mm/yy
--
Gary''s Student - gsnu200828


"Celtic Warrior" wrote:


How do I convert a date format from dd.mm.yy to dd/mm/yy?

Any help appreciated

Forgot to mention that Excel does not recognise dd.mm.yy as a date.

"Gary''s Student" wrote:

Select the cell(s) and Format Cells... Number Custom dd/mm/yy
--
Gary''s Student - gsnu200828


"Celtic Warrior" wrote:


How do I convert a date format from dd.mm.yy to dd/mm/yy?

Any help appreciated

Thanks guys for the quick response but no luck with your solution.


Warrior.




"Gary''s Student" wrote:

Select the cell(s) and Format Cells... Number Custom dd/mm/yy
--
Gary''s Student - gsnu200828


"Celtic Warrior" wrote:


How do I convert a date format from dd.mm.yy to dd/mm/yy?

Any help appreciated

Have you used the replace function under the Edit menu? That alone should do
what you want if what's in your cells is input as dd.mm.yy.

"Celtic Warrior" wrote:

Thanks guys for the quick response but no luck with your solution.


Warrior.




"Gary''s Student" wrote:

Select the cell(s) and Format Cells... Number Custom dd/mm/yy
--
Gary''s Student - gsnu200828


"Celtic Warrior" wrote:


How do I convert a date format from dd.mm.yy to dd/mm/yy?

Any help appreciated

With 25.12.08 in cell A1, in B1 enter:

=DATE(RIGHT(A1,2)+2000,MID(A1,4,2),LEFT(A1,2)) displays a real date
and
=SUBSTITUTE(A1,".","/") to display a text date
--
Gary''s Student - gsnu200828


"Celtic Warrior" wrote:

Thanks guys for the quick response but no luck with your solution.


Warrior.




"Gary''s Student" wrote:

Select the cell(s) and Format Cells... Number Custom dd/mm/yy
--
Gary''s Student - gsnu200828


"Celtic Warrior" wrote:


How do I convert a date format from dd.mm.yy to dd/mm/yy?

Any help appreciated

DataText to ColumnsNextNextColumn Data FormatDMYFinish.

Works for me in Excel 2003 with your example data.


Gord Dibben MS Excel MVP

On Wed, 21 Jan 2009 06:54:04 -0800, Celtic Warrior
wrote:

Thanks guys for the quick response but no luck with your solution.


Warrior.




"Gary''s Student" wrote:

Select the cell(s) and Format Cells... Number Custom dd/mm/yy
--
Gary''s Student - gsnu200828


"Celtic Warrior" wrote:


How do I convert a date format from dd.mm.yy to dd/mm/yy?

Any help appreciated

Thanks everyone esp Gary & Gord. Job Done.


Warrior

"Gord Dibben" wrote:

DataText to ColumnsNextNextColumn Data FormatDMYFinish.

Works for me in Excel 2003 with your example data.


Gord Dibben MS Excel MVP

On Wed, 21 Jan 2009 06:54:04 -0800, Celtic Warrior
wrote:

Thanks guys for the quick response but no luck with your solution.


Warrior.




"Gary''s Student" wrote:

Select the cell(s) and Format Cells... Number Custom dd/mm/yy
--
Gary''s Student - gsnu200828


"Celtic Warrior" wrote:


How do I convert a date format from dd.mm.yy to dd/mm/yy?

Any help appreciated