Hello,
Do you know any formula that can help me swith this date format with dashes to dots. For example, change this from 05/16/14 to 05.16.14
Please help.
Hello,
Do you know any formula that can help me swith this date format with dashes to dots. For example, change this from 05/16/14 to 05.16.14
Please help.
• Select the cells to be formatted
• CTRL+1...to open the formatting window
...Number_tab
...Category: Custom
...Type: mm.dd.yy <-Put this in the Type box
...Click: OK
Is that something you can work with?
Note: What Ron gave you changes the formatting of a date to mm.dd.yy. It does not allow you to enter a date using that periods instead of slashes. I believe you'd need VBA for that.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks for the formatting tip. However, when I use Indirect function for the new format. The indirect still read 05.16.14 as 47774 not as "05.16.14" that I expected
How'bout we save a bit of time and you post the formula you're trying to use?
I found the solution. This is the formula that I'm using. Thanks for the help.
=INDIRECT("'"&TEXT(TODAY()-1,"MM.DD.YY")&"'!$AJ6")-INDIRECT("'"&TEXT(TODAY()-2,"MM.DD.YY")&"'!$AJ6")
Glad you got something you can use!
Be sure to mark this thread as SOLVED (from the Thread Tools menu)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks