Using Excel 2007
I am trying to enter thousands of thickensss readings that were recorded manually and must be transcribed over to excel/
I have numbers like 432 433 435 431 444 Each value in its own cell
Would like the result
0.432" 0.433" 0.435" 0.431" 0.444
I would like to do this where I only enter the digits and the format results in the same cell rather than a formula target to a new result cell
I imagined this might work for the first set of number, but no [$ 0.]#0[$ "]
--------------------------------
Not in the same report I have a similar problem:
I also have some data that is 132 133 135 136 130
Would like to have result:
1.32" 1.33" 1.35" 1.36" 1.30"
Thank you for your time
Cross post
http://www.mrexcel.com/forum/showthread.php?p=2779610#post2779610
Bookmarks