Rounding issue in Excel 2000

G

GregNga

Whenever I copy and paste the following column into Excel
64082153021072309
17501818699072309
40310967596072309
07470568444072309

it is displayed as

64082153021072300
17501818699072300
40310967596072300
7470568444072309

How do I get Excel to display this without rounding up and trucating the
leading zero.
 
T

T. Valko

Excel is a real pita when doing this!

Pre-format the destination cells as TEXT then use Paste Special>Text>OK
 
M

Mike Rogers

GregNga

Excell will only handle 15 numbers as numbers, anything above 15 needs to be
handled as text. Which means you can not use them in computations.

Preceed the entry with a single quote " ' ", or formate the cell as text
before you make an entry.


Mike Rogers
 
G

GregNga

Preformatting as test yields

6.40822E+16
1.75018E+16
4.0311E+16
7.47057E+15

I am not using them in calculation, only display
 

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

Rounding numbers 3
Column Width using Ron de Bruin script 3
Excel Rounding Issue 3
How do I ROUNDUP an entire column of numbers? 3
Rounding Problem?? 1
Rounding with the sum formula 3
Number Problems 3
rounding problem in Excel 1

Top