Retain format for concatenate

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi
try
=A1 & TEXT(B1,"0000")

--
Regards
Frank Kabel
Frankfurt, Germany

Sachin said:
Hi!

Am working on coding items of Stores

As required, one of the attribuites bears 4 digits; done by
Click to expand...
'Format-Custom-0000) - so 1 displayed as 0001
 
Back
Top