I need help formatting numbers in Excel
Posted on 2013-06-12
I have a couple of ExCEL questions.
1) If I have a column of numbers without a decimal point and would like to make the two right-most characters the decimal values, how would I do this?
15895 should become 158.95
75642 should become 756.42
2) If I have a column with 10 characters and some of those characters are negative numbers with leading 0's, how can I remove the leading 0's?
000-2548 should become -2548
00-14587 should become -14587
Thank you very much in advance,