Convert a slash (/) date to a dot (.) date

[antony moseley]

Hello,

How do I convert a date that is 29/10/2017 but shows as 29-Oct into 29.10.17 ?

Thanks

Antony

[etaf]

is it actually a date
if so

custom format

dd.mm.yy

[PaulM100]

Format Cells->Custom->Type d.m.yy->Ok

[antony moseley]

Hello - I need the cell value to be 29.10.17, not just it show as this, as I use this format date for another formula

Thanks

[etaf]

so you want to change the date to text - which will nolonger work in excel as a date

what is your other formula - can it not be changed to accommodate a real date

otherwise you may need vba to change the cell contents

[antony moseley]

so you want to change the date to text - which will nolonger work in excel as a date

what is your other formula - can it not be changed to accommodate a real date

otherwise you may need vba to change the cell contents

The 29.10.17 is the name of a tab, the formula looks to this tab to get data

[PaulM100]

Then, why not using a helper column =TEXT(A1,"dd.mm.yy")?

[antony moseley]

Then, why not using a helper column =TEXT(A1,"dd.mm.yy")?

Thank you!