Number Format - leading zeros

[Guest]

I want to enter the year in a number field as 07, but it displays as 7. I
tried putting the format 00, which does what I want in Excel, but it doesn't
do it in Acess when I switch to datasheet view.

Can someone help?

Thanks,
=Ray=

 

[Guest]

Hi Ray

Numbers can't have a leading zero. If you know you only ever want 1 leading
zero (like 07) then set the format like that but it may cause a problem in
2010 (your year will be 00).

Best bet would be to set the format as text.

If you have a time/date field then set the format on a form as yy or yyyy

 

[Douglas J. Steele]

Since leading zeroes are meaningless for numeric values, there's no way to
keep them.

Try changing your field to text.