Is it possible to show leading 0's of SKU Code in Formula Bar ?

[mave27]

leading.png

Is it possible to show leading 0's of SKU code in Formula Bar ?

I've tried changing the col to Number Format; Custom Format & using Concat function (in order to apply 0 before), but can't get the "0" to show up in the Formula bar ?!

I need to show the leading zero in order to facilitate a Import to ERP system. Some SKUs in system have 0's before SKU Code.

Pls help.

[mave27]

ok - figured it out.

changed col to text & added a 0 before SKU & seems to stick !!