Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format text
Hi,
I'm having trouble with userform I've designed. The user enters the date into textbox1 and this is entered into a cell, eg. A1. The problem I have is that the date always enter the cell in teh format mm/dd/yy, even though I have formated the cell as dd/mm/yy. how can I correct this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format text
One way:
With Range("A1") .Value = CDate(Textbox1.Text) .NumberFormat = "dd/mm/yy" End With In article , "Wayne" wrote: Hi, I'm having trouble with userform I've designed. The user enters the date into textbox1 and this is entered into a cell, eg. A1. The problem I have is that the date always enter the cell in teh format mm/dd/yy, even though I have formated the cell as dd/mm/yy. how can I correct this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel |