Format Number of Digits

[EthanK]

Hi,

I'm trying to find a calculation function that will allow me to force a calculation's result to contain a certain number of digits.

So if I say 4 digits, then calculations of 1 or 15 would result in 0001 or 0015.

Any ideas?

Thanks

Ethan

[Søren Dyhr]

Well the number can't really be number but text instead:

Right("0000" & theNumber;4)

--sd

[EthanK]

Who said anything about numbers? I was talking calculations ;-)

Thanks a lot.

Ethan

[Søren Dyhr]

Ehm the header for instance

--sd