LinkBack URL
About LinkBacks
I'm trying to have the date in the mm/dd/yy format but it keeps reverting to dd/mm/yy. I have tried everything I know minus starting over from scratch. So formatting the cell and picking the correct format will not work.
any ideas
I'm trying to have the date in the mm/dd/yy format but it keeps reverting to dd/mm/yy. I have tried everything I know minus starting over from scratch. So formatting the cell and picking the correct format will not work.
any ideas
Did you ask google?
http://answers.microsoft.com/en-us/o...5758141?auth=1
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Force excel to view your date in A1 as text:Formula:
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Format
Custom
mm/dd/yy
Apply format 1st, then paste your data as values.
Pete
Don't the regional settings in Windows dictate to Excel what format the dates will be in?
You could always manipulate them as text.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I cannot recreate the problem. I can pick whatever date format I want for the given date (see sample). I entered a random date into the spreadsheet and formatted with the indicate number formats. What I see is indicated in column 3. Does your machine change all of my formatted numbers to something other than what I indicate?
You should be able to format your dates either way. I cannot explain why Excel will not allow you to format your dates (and I generally do not like converting dates to text strings, as I think that makes them harder to work with). Are there any macros running that would be changing your date formats?
Originally Posted by shg
Check your Regional Settings for date formats in the Control Panel. They are probably not correct.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
This did it!!!!
Now what I don't understand is how it changed. I've never had this issue with the worksheet. It started doing this within the last month.
Thank you Newdoverman and everyone else who offered suggestions
Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Done! Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks