Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default 39,330 = 9/5

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"