Here are some problems that our users have asked and received explanations on
Hello.
I need help with my function.
How do i add "UDSKIFT(F4;"-";"/")" into =(DATO(VENSTRE(F4;2)+2000;MIDT(F4;4;2);HØJRE(F4;2)))
I am changing date yy-mm-dd into dd/mm/yy
Solved by V. Q. in 12 mins
I need to save a excel 97-2003 file as a cvs file. But it is not keeping the excel date format of mm/dd/yy, it keeps going back to mm/dd/yyyy.
Help!
Solved by K. E. in 14 mins
Hi,
I need a formula to split the following :
Jul 23, 2018 3:21:48 PM
I need the above to be in this format dd/mm/yy. i.e. 23/07/2018
Solved by D. L. in 29 mins
I'm attempting to force my users to enter a date in a mm/dd/yy format, I do not want the information accepted unless it's entered exactly this way.
Solved by M. Y. in 17 mins
I am using Match and index function to locate interest rate in one tab by looking up the date (mm-yy). but the formula returns N/A when I use mid month date. Please Help!!!