Date Formats in Excel - Please take a quick look!!?

Question

Thanks for taking a look!

Right, I'm trying to upload a batch file which needs to have this format as date/time:

YYYY/MM/DD hh:mm:ss

The raw file that I have currently has the date as:

DD/MM/YYYY hh:mm:ss

But of course this is in fact just a number that Excel interprets and displays as a date.

So how do I change this number to plain text and in the correct date format?? Note that the batch file must be a CSV file, so it has to be plain text date in the format that I want.

Pleeeeeeeeeeease help me out. Real nightmare for me at the moment!

Many many thanks!

Answer 1

u can do so by enclosing date in either single quotes or double quotes



you just dont have to click in cell to inter quotes just type quotes in formula bar which is right above your colums and on the right side of where u can see which cell selected





or u can try this



You can use this formula (date in B2):



=TEXT(B2,"yyyy/mm/dd hh:mm:ss")

Answer 2

in case you place 12/22/09 and format it as a date you have a number of methods for excel to coach the date. in actuality all excel sees is your get admission to the format is barely a view, you could format it to declare December, 22, 2009. in case you elect to comprehend what excel sees and makes use of look into the bar on the precise while your on that cellular no rely the way it quite is formatted. once you form it is going to form utilising the numbers you typed and excel kinds via month, then day then year the two forward or backward. in case you enter the year first it gets perplexed. in case you place a ' it thinks it text cloth and could not format it as a date or a selection.

Answer 3

Go to Format Cells and select custom and type in YYYY/MM/DD hh:mm:ss



you should be good to go

copy the fields, and paste... special, values, change cell format to text...



When I open the csv in notepad, I get the results you desire..



After you save, what are you using to reopen the data?











send me the file, I will send it back

[e-mail]