How to Quickly Resolve 'Number in This Cell is Formatted as Text' Error and Convert Data to Numbers

preview_player
Показать описание
Sometime a green triangle appear in cell indicating error and if the error message says 'number in the cell is formatted as text.......', this video shows how to fix the issue. This simple method quickly removes green triangle and restores default text in the cells in Excel. If you find the video helpful, please subscribe. Thank you!
Рекомендации по теме
Комментарии
Автор

You just saved me 10, 000 clicks! Thank you so much. Great video. Direct, to the point. I salute thee!!!

michaelszabo
Автор

You sir are a legend, I couldnt get my vlookups to work until i did this. thank you

nickpearson
Автор

Finally through this video issue has been resolved thanks for uploading this...👍

mohitrao
Автор

The Right Video to the Problem! Kudos!

atmK
Автор

Thanks!!!! finally someone resolved this problem!

josemora
Автор

Thanks bro you saved me over 150 clicks

hassanibrahim
Автор

Thanks for this, it was useful. I still have this problem with bigger numbers when they finish whit 0 you lost them all. e: 4622BA50000 -> 4622BA5. Any solution for this issue?

ХристоЯнчев-яь
visit shbcf.ru