EthanK Posted February 17, 2006 Posted February 17, 2006 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 Posted February 17, 2006 Posted February 17, 2006 Well the number can't really be number but text instead: Right("0000" & theNumber;4) --sd
EthanK Posted February 17, 2006 Author Posted February 17, 2006 Who said anything about numbers? I was talking calculations ;-) Thanks a lot. Ethan
Recommended Posts
This topic is 6873 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now