It sounds like you have the column you are adding values to set for UK style
dates. I'm not sure if you want to change the old cells or just the new ones,
so here goes... highlight the cells or column you want to change.in the
"Format" pull down menu pick cells or press ctrl 1pick number tabpick date
from the choices on the leftpick the format from the choices on the rightpress
OK That should do it.
Rich White Central, IL USA
'63 TR3B TCF###L
That ain't a scrap pile, that is my car!
> To: shop-talk at Autox.Team.Net
> From: eric at megageek.com
> Date: Wed, 14 Mar 2012 15:44:25 -0400
> Subject: [Shop-talk] OT- Excel help, (before I shoot my computer)!
>
> 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/rlwhitetr3b at hotmail.com
|