Retain format for concatenate

[Guest]

Hi

Am working on coding items of Store

As required, one of the attribuites bears 4 digits; done by 'Format-Custom-0000) - so 1 displayed as 000
But cannot concatenate with other cells Ex: I get AS1 instead of AS000

Please hel

Regard
Sachin

 

[Frank Kabel]

Hi
try
=A1 & TEXT(B1,"0000")

--
Regards
Frank Kabel
Frankfurt, Germany

Hi!

Am working on coding items of Stores

As required, one of the attribuites bears 4 digits; done by

'Format-Custom-0000) - so 1 displayed as 0001

 

[Guest]

Thank a lot

Regard
Sachin