Adding leading zeros to alphanumeric text

[mathsbeauty]

Hello! I am new here. If "2" is in field, I want display in report as "02". If "*2" is in field , I want display in report as "*02" i.e. if there is only one digit with or without *, then I want to add one leading zero to make it two digit. . I hope to get some help from experts.

 

[SimonB1978]

Hi,

Format(your_number, "00") should do it.

 

[mathsbeauty]

Sorry Dear, but *2 is displayed as *2 and not as *02

 

[gaby]

Expr1: IIf((Left([f1],1)<>"*"),(Format([F1],"00")),("*" & Format((Right([f1],1)),"00")))

This will evaluate if the asterisk is present and format accordingly.

 

[mathsbeauty]

Thanks gaby, for your efforts. It just worked perfectly! Thank you very much!