| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date format of a textbox
Help me please!!!
I'v tried different codes but none seem to work.........Grrrrrrrrrrrrrr!! I have a UserForm1 which in TextBox1 should display a date which it gets it from Sheet2 cell "D2". I'm trying to format it to 14 October 2008, ( I think dd-mmm-yyyy") Can anybody help? -- Tdp |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format of a textbox
What are you getting?
In formatting if you want the full month to display, you need 4 m's, not 3. 1m = the month number, i.e.: 7, 8, 9, 10, 2m = the month number, but always 2 digits, i.e: 07, 08, 09, 10 3m = abbreviated month, i.e.: Jul, Aug, Sep, Oct 4m = full month name And if you want spaces, formatting would be: dd mmmm yyyy -- John C "Tdp" wrote: Help me please!!! I'v tried different codes but none seem to work.........Grrrrrrrrrrrrrr!! I have a UserForm1 which in TextBox1 should display a date which it gets it from Sheet2 cell "D2". I'm trying to format it to 14 October 2008, ( I think dd-mmm-yyyy") Can anybody help? -- Tdp |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format of a textbox
I am trying to format the date to English layout I keep getting the American
format. -- Tdp "John C" wrote: What are you getting? In formatting if you want the full month to display, you need 4 m's, not 3. 1m = the month number, i.e.: 7, 8, 9, 10, 2m = the month number, but always 2 digits, i.e: 07, 08, 09, 10 3m = abbreviated month, i.e.: Jul, Aug, Sep, Oct 4m = full month name And if you want spaces, formatting would be: dd mmmm yyyy -- John C "Tdp" wrote: Help me please!!! I'v tried different codes but none seem to work.........Grrrrrrrrrrrrrr!! I have a UserForm1 which in TextBox1 should display a date which it gets it from Sheet2 cell "D2". I'm trying to format it to 14 October 2008, ( I think dd-mmm-yyyy") Can anybody help? -- Tdp |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format of a textbox
What is your computer's regional settings?
-- John C "Tdp" wrote: I am trying to format the date to English layout I keep getting the American format. -- Tdp "John C" wrote: What are you getting? In formatting if you want the full month to display, you need 4 m's, not 3. 1m = the month number, i.e.: 7, 8, 9, 10, 2m = the month number, but always 2 digits, i.e: 07, 08, 09, 10 3m = abbreviated month, i.e.: Jul, Aug, Sep, Oct 4m = full month name And if you want spaces, formatting would be: dd mmmm yyyy -- John C "Tdp" wrote: Help me please!!! I'v tried different codes but none seem to work.........Grrrrrrrrrrrrrr!! I have a UserForm1 which in TextBox1 should display a date which it gets it from Sheet2 cell "D2". I'm trying to format it to 14 October 2008, ( I think dd-mmm-yyyy") Can anybody help? -- Tdp |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format of a textbox
English(United Kingdom)
-- Tdp "John C" wrote: What is your computer's regional settings? -- John C "Tdp" wrote: I am trying to format the date to English layout I keep getting the American format. -- Tdp "John C" wrote: What are you getting? In formatting if you want the full month to display, you need 4 m's, not 3. 1m = the month number, i.e.: 7, 8, 9, 10, 2m = the month number, but always 2 digits, i.e: 07, 08, 09, 10 3m = abbreviated month, i.e.: Jul, Aug, Sep, Oct 4m = full month name And if you want spaces, formatting would be: dd mmmm yyyy -- John C "Tdp" wrote: Help me please!!! I'v tried different codes but none seem to work.........Grrrrrrrrrrrrrr!! I have a UserForm1 which in TextBox1 should display a date which it gets it from Sheet2 cell "D2". I'm trying to format it to 14 October 2008, ( I think dd-mmm-yyyy") Can anybody help? -- Tdp |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format of a textbox
What result are you getting when you format
dd-mmm-yyyy or even dd mmmm yyyy -- John C "Tdp" wrote: English(United Kingdom) -- Tdp "John C" wrote: What is your computer's regional settings? -- John C "Tdp" wrote: I am trying to format the date to English layout I keep getting the American format. -- Tdp "John C" wrote: What are you getting? In formatting if you want the full month to display, you need 4 m's, not 3. 1m = the month number, i.e.: 7, 8, 9, 10, 2m = the month number, but always 2 digits, i.e: 07, 08, 09, 10 3m = abbreviated month, i.e.: Jul, Aug, Sep, Oct 4m = full month name And if you want spaces, formatting would be: dd mmmm yyyy -- John C "Tdp" wrote: Help me please!!! I'v tried different codes but none seem to work.........Grrrrrrrrrrrrrr!! I have a UserForm1 which in TextBox1 should display a date which it gets it from Sheet2 cell "D2". I'm trying to format it to 14 October 2008, ( I think dd-mmm-yyyy") Can anybody help? -- Tdp |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format of a textbox
"Tdp" wrote: Help me please!!! I'v tried different codes but none seem to work.........Grrrrrrrrrrrrrr!! I have a UserForm1 which in TextBox1 should display a date which it gets it from Sheet2 cell "D2". I'm trying to format it to 14 October 2008, ( I think dd-mmm-yyyy") Can anybody help? -- Tdp |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need A date Mask format for a Textbox on UserForm | Excel Discussion (Misc queries) | |||
| TextBox format? | Excel Discussion (Misc queries) | |||
| Textbox date format. | Excel Discussion (Misc queries) | |||
| Date format textbox | Excel Discussion (Misc queries) | |||
| TextBox Format | Excel Discussion (Misc queries) | |||
Hybrid Mode
