Number Format - leading zeros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

=Ray= - 14 Jun 2007 16:16 GMT

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=

Reply to this Message

Wayne-I-M - 14 Jun 2007 16:55 GMT

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

Signature

Wayne
Manchester, England.

> 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
[quoted text clipped - 4 lines]
> Thanks,
> =Ray=

Reply to this Message

Douglas J. Steele - 14 Jun 2007 16:58 GMT

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

Try changing your field to text.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>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
[quoted text clipped - 5 lines]
> Thanks,
> =Ray=

Reply to this Message