5000元1吨一公斤是价钱？

1吨等于（1000）公斤；

1公斤=1千克。

5000－500＝4500元，4500÷（3×1000）＝1.5元

假设12.34在A1，在B1输入=IF(A1<0,"负","")&IF(TRUNC(A1)=A1,TEXT(IF(A1<0,-A1,A1),"[DBNum2]")&"吨整",IF(TRUNC(A1*10)=A1*10,TEXT(TRUNC(IF(A1<0,-A1,A1)),"[DBNum2]")&"吨"&TEXT(RIGHT(A1)*100,"[DBNum2]")&"公斤",TEXT(TRUNC(A1),"[DBNum2]")&"吨"&IF(ISNUMBER(FIND(".0",A1)),"零",TEXT(LEFT(RIGHT(A1,2))*100,"[DBNum2]")&TEXT(RIGHT(A1)*10,"[DBNum2]")&"公斤")))

1吨=1000公斤