I have a worksheet which breaks down quantities from column AB2 based on column AS statisical unit consists of kg L,U,m,m3 2u .
on column u qty1 header using formula below
my issue that now the column U shows no more ea ,pks, in the digits. that 30.00EA OR 30.00PKS now reads 30,2 ,15 and so on.Please Login or Register to view this content.
column BC is the example that column U will show now .
Can anyone assists , the issue of the formula is in red as below.
Bookmarks