|  | Date in CAPS | | |
| | | Mark.M.Sweeney@gmail.com |  |
|  Posted: Fri Aug 29, 2008 6:43 pm Post subject: Date in CAPS |  |
I've got a cell with a date that the user types in. Currently, the
user types a date in and it automatically changes the format to
DDMMMYYYY.
I need the MMM to be in all caps so that it feeds a SQL string
correctly but can't find a way to do this.
Any suggestions is appreciated.
Mark |
| |
| | | Rick Rothstein | |
| | Posted: Fri Aug 29, 2008 7:18 pm Post subject: Re: Date in CAPS | |
Using 2 M's lists the month number with two digits (leading zero where
necessary), using 3 M's lists the abbreviated name of the month (and using 4
M's would list the month's full name).
--
Rick (MVP - Excel)
"Tangier" <nitinhemmady@gmail.com> wrote in message
news:30dae72c-851a-4302-a3ad-356acc9c79d9@59g2000hsb.googlegroups.com...
On Aug 29, 1:43 pm, "Mark.M.Swee...@gmail.com"
<Mark.M.Swee...@gmail.com> wrote:
| Quote: | I've got a cell with a date that the user types in. Currently, the
user types a date in and it automatically changes the format to
DDMMMYYYY.
I need the MMM to be in all caps so that it feeds a SQL string
correctly but can't find a way to do this.
Any suggestions is appreciated.
Mark
|
one question is why does your date mask have MMM instead of MM? |
| |
| | | Tangier | |
| | Posted: Fri Aug 29, 2008 9:00 pm Post subject: Re: Date in CAPS | |
On Aug 29, 1:43 pm, "Mark.M.Swee...@gmail.com"
<Mark.M.Swee...@gmail.com> wrote:
| Quote: | I've got a cell with a date that the user types in. Currently, the
user types a date in and it automatically changes the format to
DDMMMYYYY.
I need the MMM to be in all caps so that it feeds a SQL string
correctly but can't find a way to do this.
Any suggestions is appreciated.
Mark
|
one question is why does your date mask have MMM instead of MM? |
| |
| | | Héctor Miguel | |
| | Posted: Sun Aug 31, 2008 1:28 am Post subject: Re: Date in CAPS | |
hi, Mark !
| Quote: | I've got a cell with a date that the user types in.
Currently, the user types a date in and it automatically changes the format to DDMMMYYYY.
I need the MMM to be in all caps so that it feeds a SQL string correctly but can't find a way to do this.
Any suggestions is appreciated.
|
*IF* your SQL string is built by code... try enclosing "the cell" within vba function UCase(<the_cell>.Text)
otherwise, see Stephen Bullen's: LINK
for working with dates between excel, regional settings, user customes, ...
hth,
hector. |
| |
|
|
