Hi all ...
My supervisor told me that we needed to add two columns to our sheets, one being [=TODAY()] and second [=TODAY()+30] and we need it formatted as yyyy/mm/dd hh:mm:ss
We have to save our final files in CSV.
Fine and dandy until ... you have to reopen the file for any reason. The format converts to a built in format for the function.
What I'm wanting to do is - since columns are just filled down - to copy the value of the format from the function as text so that I can simply avoid having to change it over and over.
(Another issue that Excel seem to LOVE to do, is combine the cell in to an odd number every time the cell is sized too small for the whole format to be seen - but I know that cannot be avoided...)
My supervisor told me that we needed to add two columns to our sheets, one being [=TODAY()] and second [=TODAY()+30] and we need it formatted as yyyy/mm/dd hh:mm:ss
We have to save our final files in CSV.
Fine and dandy until ... you have to reopen the file for any reason. The format converts to a built in format for the function.
What I'm wanting to do is - since columns are just filled down - to copy the value of the format from the function as text so that I can simply avoid having to change it over and over.
(Another issue that Excel seem to LOVE to do, is combine the cell in to an odd number every time the cell is sized too small for the whole format to be seen - but I know that cannot be avoided...)
