Forum Discussion

Andrej Masaryk's avatar
Andrej Masaryk
Copper Contributor
Nov 13, 2018

number XI,26 ??

Hi everybody. I need help ... in my worksheet have more number type XI,27 or 76,VII ... how to repair to number 9,27 or 76,7? 

 

pls help. 

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    copy your data to another sheet and test it there.
    try formatting the cells as TEXT.
    HTH

Resources