Hello,
How do I convert a date that is 29/10/2017 but shows as 29-Oct into 29.10.17 ?
Thanks
Antony
Hello,
How do I convert a date that is 29/10/2017 but shows as 29-Oct into 29.10.17 ?
Thanks
Antony
Last edited by antony moseley; 11-23-2017 at 11:24 AM.
is it actually a date
if so
custom format
dd.mm.yy
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Format Cells->Custom->Type d.m.yy->Ok
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
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
Then, why not using a helper column =TEXT(A1,"dd.mm.yy")?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks