If you want to convert it into a text value then you can use this
formula in a helper column:

=TEXT(A1,"yyyy-dd-mm")

assuming the date is in A1. Copy the formula down, then you can fix
the values by highlighting the cells with the formula in, click <copy
then Edit | Paste Special | Values (check) | OK then <Esc. Now you
can copy/paste the helper cells over the original data, and then
delete the helper column.

Hope this helps.

Pete

On Apr 11, 7:29*pm, Ks DRM wrote:
I have imported a date field in the form of dd/mm/yyyy which i formatted
through excel to yyyy-dd-mm.

However this only affects the display and does not actually change the input
to the same format.

How I have the input converted to this format as I need to export it in csv
which only takes the input and does not carry the formatting.