Thread
:
Format date dd.mm.yyyy to dd/mm/yyyy
View Single Post
#
2
Frank Kabel
Posts: n/a
Hi
sounds like your date values are actually stored as 'Text'- you may try
using 'Data - Text to columns' to convert them to real dates
--
Regards
Frank Kabel
Frankfurt, Germany
"Kiwi User" <Kiwi
schrieb im
Newsbeitrag ...
Hi,
For exporting purposes to a database, I have to have the dates
formatted as
dd/mm/yyyy. Easy you say. Yes, I have formatted the column to be a
date and
selected dd/mm/yyyy as the format. Great
Only, it changes the date in any written form EXCEPT where dots are
used.
Is there a way I can format by validation or some such thing to error
or
replace "." with "/" (i.e dots with slashes.)
Cheers
Reply With Quote