Using format()

Rodolfo Fontes · Sep 20, 2004

Hi group,

How can I set a number to be like this?
Original: 123456
Result: 000012345600

Thanks,
Rodolfo Fontes

Perry · Sep 20, 2004

Off the immediate window

? format("123456", "0000000000") & "00"
000012345600
? format("000456", "0000000000") & "00"
000000045600
? format("120456", "0000000000") & "00"
000012045600

Krgrds,
Perry