Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I copy a page from the Internet into my spread sheet. It's a table
and everything transposes OK, except fractions like 9/5. In my spreadsheet it reads 39,330. Only the fractions do this. Here are some others: 9/2 = 4.5 = 39,327 7/2 = 3.5 = 39,265 5/2 = 2.5 = 39,204 9/5 = 1.8 = 39,330 8/5 = 1.6 = 39,299 3/2 = 1.5 = 7/5 = 1.4 = 6/5 = 1.2 = 4/5 = 0.8 = 3/5 = 0.6 = 0 = 0.4 = I don't have them all yet, but I'm sure there is a mathematical corelation. As soon as I see the rest of them I'll have them. The frist column is how they look when I copy them. The second column is how I want them to look, and the third column is how they show up. Anyway, when I paste them into my spreadsheet how can I make them show up as 4.5, 3.5, 2.5, etc? Thank you |