| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make date entered in an InputBox UK format
Hi,
I have a simple InputBox in excel which keys in a date into a single cell. But when I key in 01/04/2006 the inputbox interprets the date to be 4th Jan 2006 rather than 1st April 2006. is there anyway I can change this so it uses the English date format rather than US? Please help! Thanks Brian Manchester,England |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make Day CAPS In Custom Date Format | Excel Worksheet Functions | |||
| Excel 2002: How to make the date format uniform ? | Excel Discussion (Misc queries) | |||
| Condit Format? Make date change colors | Excel Worksheet Functions | |||
| How to make xy plot of date format data in both columns | Charts and Charting in Excel | |||
| how do i make a value entered be * 2 | New Users to Excel | |||
Threaded Mode
