By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

leading 0

P: n/a
which number field setting will display leading zero's?
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
None!

Mathematically, there is no number that has (a) leading 0(s). 0, 1, 2,3 .... ad
infinitum. If you want a numerical expression with leading 0s, you need to make
it a text field.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com
"AdmirableKnight" <ad*************@aol.com> wrote in message
news:20***************************@mb-m13.aol.com...
which number field setting will display leading zero's?

Nov 12 '05 #2

P: n/a
I realise it doesnt feature in all number sets but for when listing Tel No's
for example it would be handy . Would have thought its possible as its used in
binary code?
Nov 12 '05 #3

P: n/a
In article <20***************************@mb-m23.aol.com>,
ad*************@aol.com says...
I realise it doesnt feature in all number sets but for when listing Tel No's
for example it would be handy . Would have thought its possible as its used in
binary code?


Dont confuse the storage of data and the display of the data. Two 100%
separate things. Don't force the data you store to look like anything
in particular that is irrelevant.

Data Stored:
PhoneNumber -> 123456

Data Displayed:
Right("0000000" & PhoneNumber,7)

Display Results:
0123456

--
http://www.Obscenitees.com
These shirts are funny!

Nov 12 '05 #4

P: n/a
On 06 Oct 2003 10:19:49 GMT in comp.databases.ms-access,
ad*************@aol.com (AdmirableKnight) wrote:
which number field setting will display leading zero's?


Input mask or format property.

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.