Formatting numbers and date

  • Thread starter Thread starter Sunayan Sanatani
  • Start date Start 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
 
You can type formats even if they don't appear in the list.

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