Just wondering if there is a way to get '14,037,000' to 14,037 by using a formular
L Lost Aug 11, 2005 #1 Just wondering if there is a way to get '14,037,000' to 14,037 by using a formular
M Mangesh Yadav Aug 11, 2005 #2 You could simply divide by 1000. And if you have intentionaaly put the single quotes, then assuming your text '14,037,000' lies in cell A1, then use: =SUBSTITUTE(A1,"'","")/1000 Mangesh
You could simply divide by 1000. And if you have intentionaaly put the single quotes, then assuming your text '14,037,000' lies in cell A1, then use: =SUBSTITUTE(A1,"'","")/1000 Mangesh
B Bob Phillips Aug 11, 2005 #4 You could also use a format, say [>999999]#,##0,\M;[>999]#,##0,\T;#,##0
