If you want your output prefilled with zeroes use
=right('00000'+@location, 5))
If you want it postfilled with zeroes use
=left(@location+'00000', 5))