shop-talk
[Top] [All Lists]

[Shop-talk] OT- Excel help, (before I shoot my computer)!

Subject: [Shop-talk] OT- Excel help, (before I shoot my computer)!
From: tr3driver at ca.rr.com (Randall)
Date: Wed, 14 Mar 2012 15:03:41 -0700
References: <OF2571289B.992796CE-ON852579C1.006C4D05-852579C1.006D1806@mail.megageek.com>
> 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.

The cell format in Excel only controls how the cell value is displayed, NOT
how it is entered.  I believe that, in order to change the entry method, you
need to change the regional options in Control Panel, which of course
changes it for the entire system not just Excel.

To do what you want within Excel without changing the system date format, I
think you will have to enter the date as a string, and then use a formula
(or VB script) to do the conversion.

Or, here is a plug-in (which I know absolutely nothing else about) that
claims to do it for you:
http://www.rondebruin.nl/qde.htm

-- Randall 

<Prev in Thread] Current Thread [Next in Thread>