format cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access, I can set up a field that "forces" the user to enter info - a
date, for example - in a certain way, such as 25 Jan 05 or enter time as
12:15 AM. Is there a way that I can "force" this in excel?

Thank you.
 
Hello-

Without invoking something more technical, you can select the cell(s) and go
to Data>Validation and choose what type of entry be allowed in the field.
Format the cell in the manner you wish to have the date or time expressed.

HTH |:>)
 
Hi - cannot seem to make it work - wonder if you could tell me what I might
be missing.

I went to FORMAT CELL and set custom as follows d mmm, yy
I then went to VALIDATE and selected SETTING and CUSTOM and in the formula
cell wrote d mmm, yy

When I type 3 Sep, 05 into the cell I get a message that I should use the
correct format for the date. Similar thing happens with time column - maybe
just a little thing but I am stumped.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting cells to only upper case 5
Auto Cell Format Change from General to Custom Date 1
format time problem 5
Format Cells for Hexidecimal (custom?) 1
Conditional formatting in Excel 2010 2
formatting of date 4
Excel Pivot Tables remainder of the row 1
Macro to add numbers in a text string 5

Back
Top