cancel
Showing results for 
Search instead for 
Did you mean: 

Force leading zeros

Former Member
0 Kudos

For some reason I can't remember how to force a number to show leading zeros in a fixed length field, i.e. 80 is 0080, 240 as 0240. I'd blame it on Monday but I couldn't think of it on Friday, either.

Thanks!

Robin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

cstr(,"00000000")

Former Member
0 Kudos

Thanks for your response. I had to change the cstr to totext in order for it to work, but then it was perfect!

Answers (0)