can I format excel to see over 15 digits?

8

818jaime

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

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

ps. If you're pasting, then paste the value into the formulabar. It'll avoid
problems.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

15 minute data to daily data 1
Printing Outline view - formatting lost 0
Excel does not accept text format! 0
New computer, how do i move outlook 365 ENTIRELY? 0
Paragraph numbering in Word 1
Embed the same Excel multiple times 0
Inconsistent formatting of section numbers 0
How to save a 15 digit # in CSV without it changing to a formula? 1

Top