Microsoft Office Questions? Ask a IT Expert for Support ASAP
In your system is the above date 1 March, or 3 Jan
really it exported out of my software /mm/yyyy h:mm
it needs to be mm/dd/yyyy h:mm
Assuming that exported date is a real date and not 'text' that looks like a date
If that date is in A2, type the following formula in B2
If the exported value is text then I will need your file so I can set up the correct formula for converting it
Hope this is ok. Let me know if you have any questions
No problem I will help you fix all the dates on that sheet, but I want to know if that formula worked on the single date in A2
you still there?
that worked for the first 12 but didn't for the following:
Ok that means your imported data is not consistent. In that case I need your file so I can create other formulas to cover all possibilities (let me know if you need help attaching files on this site)
In the meantime you can go ahead and rate my answer if it worked on the date format given in your initial question so I can get credit for my time. Thanks
I cant do that. I have several files with the same issue. Thanks anyway.
You can send me a sample file so I can show you how to do it. However if you wish to discontinue that's your choice but please make sure you rate my answer positive so I get paid for my work