EthanK Posted February 17, 2006 Share 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 Link to comment Share on other sites More sharing options...
Søren Dyhr Posted February 17, 2006 Share Posted February 17, 2006 Well the number can't really be number but text instead: Right("0000" & theNumber;4) --sd Link to comment Share on other sites More sharing options...
EthanK Posted February 17, 2006 Author Share Posted February 17, 2006 Who said anything about numbers? I was talking calculations ;-) Thanks a lot. Ethan Link to comment Share on other sites More sharing options...
Søren Dyhr Posted February 17, 2006 Share Posted February 17, 2006 Ehm the header for instance --sd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6640 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