Hello there! Help me Create macro that converts KG to Metric Ton, Newbie in excel

[Bossmaster]

Good day,

I used ODBC to output the data into excel cell but dont know how to convert the KG to MT on that specific cell, do i need a macro or just a simple mathematical
equation, i already so a simple equation but my problem is once i pump data on the excel, information will start fill after the rows with formulas.

Please see the sample output file,Database Output.xlsx

Ill be glad if there's anyone out there can help and suggest.


Thanks in Advanced :-)

[FDibbins]

Hi, welcome to the forum

I have not loaded your file, but take a look at the =CONVERT() function

[Bossmaster]

Hi, welcome to the forum

I have not loaded your file, but take a look at the =CONVERT() function

I already tested that one but if that cell contains formula, my data pump will starts after the rows with formula, that why im thinking that used the macro and do the conversion on the specific cell, can refer on the attached file, sorry very new in excel macro thanks :-)