As you said, the custom format can fix the display problem.
I'm not sure I follow the data-entry problem. Are you reading dates off of
forms and manually typing them in one at a time? If so, you are trying to
avoid having to reverse the day and month as you type? You could work
around this by having a column for day, month, year, then in another column
use the date() function to combine the day, month, year in the proper
order.
Or, are you pasting in a bunch of dates in UK format?
- Ian
On Wed, Mar 14, 2012 at 3:44 PM, <eric at megageek.com> wrote:
> Sorry about the off topic post, but my back is against the wall and I
> don't know where else to turn.
>
> Here is the issue...
>
> I have an excel spreadsheet that has to have a date cell in the format
> dd/mm/yy. No problem. I set the language to English "UK" and I can select
> that format.
>
> Now the problem...
>
> If I enter a date in that format, Excel flips it. (Ex. If I type in
> "03/09/06" Excel will translate it to "09/03/06" when I move to another
> cell.)
>
> If I use a date like "15/03/06" it will not move the date, BUT, I can't
> run formulas against the cell (which is something I need to do.)
>
> It seems like excel will only except me typing in a date in the format of
> month-day-year no matter what. Since the form I get the dates from isn't
> like this, it will be way too confusing to continue doing that format.
>
> I've tried creating a custom date cell format and it does the same thing.
>
> Note: this is excel 2003 version on an XP machine. But it also does this
> on Vista machine with Excel 2007.
>
> HELP!!!!
>
> Thanks in advance.
>
> Shop content, I can't go work in the shop until I finish this spreadsheet!
>
> Eric P
> "Be as beneficent as the sun or the sea, but if your rights as a rational
> being are trenched on, die on the first inch of your territory." Ralph
> Waldo Emerson
> _______________________________________________
>
> Shop-talk at autox.team.net
> Donate: http://www.team.net/donate.html
> Suggested annual donation $12.96
> Archive: http://www.team.net/archive
> Forums: http://www.team.net/forums
> Unsubscribe/Manage:
> http://autox.team.net/mailman/options/shop-talk/shop-talk2 at mcfetridge.org
|