You might have to temporarily change the PC's date format to UK - enter
the data then change it back.
On 14/03/2012 19:44, 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/neiljsherry at talktalk.net
|