8 818jaime Nov 29, 2010 #1 When I copy paste it can only see 15 numbers the 16th and 17th it displays 0's can this be chaged to display proper numbers?
When I copy paste it can only see 15 numbers the 16th and 17th it displays 0's can this be chaged to display proper numbers?
D Dave Peterson Nov 30, 2010 #2 Only if you treat the cell as text (preformat the cell as text), then enter the value. Or start your entry with an apostrophe ('1234123412341234)
Only if you treat the cell as text (preformat the cell as text), then enter the value. Or start your entry with an apostrophe ('1234123412341234)
D Dave Peterson Nov 30, 2010 #3 ps. If you're pasting, then paste the value into the formulabar. It'll avoid problems.
