You can try a way.... follow below step
Assuming your data is in A column, then select the whole B column->>>> In B1 Cell put =CONCATENATE("",F3) and press control enter. By this way all value will convert in text format and no one function will calculate their value.
Hope it will help you![]()
Bookmarks