Formatting numbers and date

S

Sunayan Sanatani

I am not able to get anything from the help section in Access regarding the
two things that I want to do:

(1) want to enter date in any record in the format dd/mm/yyyy and this is
not available as an option.The closest I can get to is dd-month-yy( eg
17-May-04 ) and this is not what I need.

(2) Want to enter numbers with leading zeros eg the number displayed in any
record must be always a five digit one ( 323 should be displayed as 00323,
4561 and 04561 and 23596 as just that)

I am able to do both the above in Excel but somehow in Access the formatting
options do not appear to be available

Thanks and regards

Sunayan
 
D

Douglas J. Steele

You can type formats even if they don't appear in the list.

Try dd/mm/yyyy and 00000 as formats.
 
Top