What mid does is to read what is says, as simple as that. So you want it to read anything but the k and then multiply by 1000 like: 19.4k you want it to read: 1,4 1,4 is: 1 - 9 - . - 4 So it is now: 19.4 =MID(Index(ImportHtml("(InsertHtml)","table",2),2,3), 1,4)*1000 Mills: multiply by 1.000.000 199.4k Is: 1,5