P paramnayak Member Jul 9, 2018 #1 hi all, I want to format a cell in such a way that if i type 45 M in the cell , the outcome should be 45 kg / M
hi all, I want to format a cell in such a way that if i type 45 M in the cell , the outcome should be 45 kg / M
B bosco_yip Excel Ninja Jul 9, 2018 #2 Type "45 M" in the cell, can't format to "45 kg / M", Custom Format cell must be a number, and "45 M" is a text. Regards Bosco
Type "45 M" in the cell, can't format to "45 kg / M", Custom Format cell must be a number, and "45 M" is a text. Regards Bosco
