Hi,
I would like to change the form of the date which I now have in the text format as January 1, 2010. I need it to be 1/1/10. Can you please help me with it?
Thank you very much.
Klara
Hi,
I would like to change the form of the date which I now have in the text format as January 1, 2010. I need it to be 1/1/10. Can you please help me with it?
Thank you very much.
Klara
If your data in "A2" as January 1, 2010 format as text.
In "B2"
Formula:Please Login or Register to view this content.
Format as "Date"
From Type select 3/14/01 (Ensure Locale Location is "English U.S.)
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks