Adding specific number to imported data

shlokhan

What's the best possible way of adding '0's to imported data?

Eg:

Data > Required Data

156 > 00156

23 > 00023

62797 > 62797

0 > 00000

rob_marshall

@shlokhan

Give this a try:

Right("00000"&text(Data),5)

shlokhan

Thanks @rob_marshall. Worked like a charm!