Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 97 Form
Hi, I would be really grateful if someone could help out as I am bashing my
head against a wall over here! I have a data form in excel. Certain records can be updated within the body of the form. The problem I have is that I need the date in dd_mmm_yy format, but when the information is entered on the form, it is in American format. Which is fine, except for, when you click on the field, it inserts a space before the date - which means it can't be formated to the desired format without going into the cell and deleting the space. However, when I tab through the record I don't get the same problem!! Is there anyway I can just make it in the above format? Very grateful for any assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I concatenate information in Excel and keep the number form | Excel Worksheet Functions | |||
Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
merge excel form with excel datadase how can i do | Excel Worksheet Functions | |||
How do I set up a field in an Excel form to number it incremental. | Excel Worksheet Functions |