GolfHos
 
*
April 18, 2024, 05:52:49 AM
Username: Password: Duration:

Decimal Chart?

 
Pages: [1] 2 3   Go Down
  Print  
Author Topic: Decimal Chart?  (Read 5448 times)
0 Members and 1 Lurker/Spider are viewing this topic.
stroh
Sleeveless Hoodie
From: Impact Crater Springs, CA

Karma: 155
Posts: 16135
Offline Offline

We're doomed!

View ProfileIgnore this user
Decimal Chart?
« on: January 20, 2008, 08:47:27 AM »

I need a decimal chart for Maddie's homework.  Anyone know of one online, or an easy(ier) way to make one? Without having to type it all, or write it long hand.
I tried, and Excel will count up for you, but it drops the zeros when not needed, and doesn't align the decimal points.  Makes it tough (for her) to read.

Need something like:
000.000
000.001
000.002
000.003
   ~
001.231
001.232

etc.

Muchos Garcias!  Smiley
Logged Return to Top
Aske
Lederhosen

Karma: 120
Posts: 31405
Offline Offline


View ProfileIgnore this user
Re: Decimal Chart?
« Reply #1 on: January 20, 2008, 09:03:02 AM »

Excel


1. Create Fill Series   (enter 0.000, 0.001, 0.002, drag down to end)
2. Highlight all cells
3. Right Click and choose Format Cells
4. Leftmost Tab , choose 'Number'
5. Enter the # of decimal places to always retain in view ( in your case,  3 would force 0.010 to show instead of 0.01)
6. Paypal aske  lots of $
Logged Return to Top

Quote
Russia has invaded a sovereign neighboring state and threatens a democratic government elected by its people. Such an action is unacceptable in the 21st century.
--  Chimpy McFlightsuit, CEO of Bu$hco Industries of 'Merka
Fuzzy
Full Metal Jacket
From: Island of Misfit Toys

Karma: 61
Posts: 4836
Offline Offline


View ProfileIgnore this user
Re: Decimal Chart?
« Reply #2 on: January 20, 2008, 09:08:52 AM »

Excel


1. Create Fill Series   (enter 0.000, 0.001, 0.002, drag down to end)
2. Highlight all cells
3. Right Click and choose Format Cells
4. Leftmost Tab , choose 'Number'
5. Enter the # of decimal places to always retain in view ( in your case,  3 would force 0.010 to show instead of 0.01)
6. Paypal aske  lots of $


If you get lots of $ for this you're in the wrong line of work.  Wink Grin


Logged Return to Top

"You have brains in your head. You have feet in your shoes. You can steer yourself any direction you choose."
From Oh the Places You'll Go, by Dr. Seuss (Theodor Geisel)
stroh
Sleeveless Hoodie
From: Impact Crater Springs, CA

Karma: 155
Posts: 16135
Offline Offline

We're doomed!

View ProfileIgnore this user
Re: Decimal Chart?
« Reply #3 on: January 20, 2008, 09:11:32 AM »

Excel


1. Create Fill Series   (enter 0.000, 0.001, 0.002, drag down to end)
2. Highlight all cells
3. Right Click and choose Format Cells
4. Leftmost Tab , choose 'Number'
5. Enter the # of decimal places to always retain in view ( in your case,  3 would force 0.010 to show instead of 0.01)
6. Paypal aske  lots of $


It will let me drag down, but not down and over.  Do I have to do it one column at a time?
Logged Return to Top
gleek
Flak Jacket

Karma: 107
Posts: 9510
Offline Offline

E chu ta!

View ProfileIgnore this user
Re: Decimal Chart?
« Reply #4 on: January 20, 2008, 09:40:58 AM »

What's a decimal chart? Do you mean a fraction-decimal conversion chart? Or is it just a single list of numbers from .001 to whatever?
Logged Return to Top

Woman, open the door, don't let it sting. I wanna breathe that fire again.
gleek
Flak Jacket

Karma: 107
Posts: 9510
Offline Offline

E chu ta!

View ProfileIgnore this user
Re: Decimal Chart?
« Reply #5 on: January 20, 2008, 09:53:06 AM »

BTW, if you figure out how to fill in the cells, the correct format should be "0000.000" (without quotes) under "Custom"--not "Number". You can PayPal me, and I'll see to it that Aske gets his share. Grin
Logged Return to Top

Woman, open the door, don't let it sting. I wanna breathe that fire again.
Seamus
Straitjacket

Karma: 52
Posts: 2376
Offline Offline

I'm a juvenile acting product of the working class

View ProfileIgnore this user
Re: Decimal Chart?
« Reply #6 on: January 20, 2008, 09:53:57 AM »

Quote
What's a decimal chart?
Everything you need is right in here.
Logged Return to Top
stroh
Sleeveless Hoodie
From: Impact Crater Springs, CA

Karma: 155
Posts: 16135
Offline Offline

We're doomed!

View ProfileIgnore this user
Re: Decimal Chart?
« Reply #7 on: January 20, 2008, 10:05:05 AM »

What's a decimal chart? Do you mean a fraction-decimal conversion chart? Or is it just a single list of numbers from .001 to whatever?

The second one.  Smiley
Logged Return to Top
stroh
Sleeveless Hoodie
From: Impact Crater Springs, CA

Karma: 155
Posts: 16135
Offline Offline

We're doomed!

View ProfileIgnore this user
Re: Decimal Chart?
« Reply #8 on: January 20, 2008, 10:12:41 AM »

Excel


1. Create Fill Series   (enter 0.000, 0.001, 0.002, drag down to end)
2. Highlight all cells
3. Right Click and choose Format Cells
4. Leftmost Tab , choose 'Number'
5. Enter the # of decimal places to always retain in view ( in your case,  3 would force 0.010 to show instead of 0.01)
6. Paypal aske  lots of $


Doesn't work.
Logged Return to Top
spacey
Amazing Technicolor Dreamcoat
From: Group W Bench

Karma: 98
Posts: 7733
Offline Offline


View ProfileIgnore this user
Re: Decimal Chart?
« Reply #9 on: January 20, 2008, 10:44:04 AM »

Like this?

* Book1.xls (90 KB - downloaded 101 times.)
Logged Return to Top
stroh
Sleeveless Hoodie
From: Impact Crater Springs, CA

Karma: 155
Posts: 16135
Offline Offline

We're doomed!

View ProfileIgnore this user
Re: Decimal Chart?
« Reply #10 on: January 20, 2008, 10:58:45 AM »

Like this?

Can't open it.  Sad  I wonder if that's the problem.  I don't have Excel?  I guess I just have "MS Works Spreadsheet" ?
Logged Return to Top
Seamus
Straitjacket

Karma: 52
Posts: 2376
Offline Offline

I'm a juvenile acting product of the working class

View ProfileIgnore this user
Re: Decimal Chart?
« Reply #11 on: January 20, 2008, 11:00:44 AM »

Like this?

Can't open it.  Sad  I wonder if that's the problem.  I don't have Excel?  I guess I just have "MS Works Spreadsheet" ?
Must be, I opened it and it looks exactly like what you wanted.

I don't know how you feel about Morpheus, but it's a way to download programs like Excel for free. I ended up downloading too much free pron, had to un install it. LOL.
Logged Return to Top
spacey
Amazing Technicolor Dreamcoat
From: Group W Bench

Karma: 98
Posts: 7733
Offline Offline


View ProfileIgnore this user
Re: Decimal Chart?
« Reply #12 on: January 20, 2008, 11:03:34 AM »

http://www.microsoft.com/...ks/more/worktogether.mspx
Logged Return to Top
gleek
Flak Jacket

Karma: 107
Posts: 9510
Offline Offline

E chu ta!

View ProfileIgnore this user
Re: Decimal Chart?
« Reply #13 on: January 20, 2008, 11:04:42 AM »

Copy this into a blank text file on your desktop. Rename the file "Decimals.htm", and load it into your browser.

Code:
<html>
<head>
<title>Decimal Chart</title>
<script type="text/javascript">
function OnChange(txt)
{
var ihtml = "";
var div = document.getElementById("divtable")

var cnt = parseInt(txt.value);
for (i=0; i<cnt+1; i++)
{
ihtml+= '<span>' + FormatNum(i) + '</span><br/>';
}
div.innerHTML = ihtml;
}

function FormatNum(n)
{
var ip = Math.floor(n/1000);
var dp = n % 1000;
return PadZeros(ip) + '.' + PadZeros(dp);
}

function PadZeros(v)
{
var x;
if (v < 10)
{
return '00' + v.toString();
}
if (v < 100)
{
return '0' + v.toString();
}
if (v < 1000)
{
return v.toString();
}
return '';
}

</script>

</head>

<body>
<span>Number of items:</span><input type="text" id="txtnumber" value="0" onchange="OnChange(this)"></input>
<div id="divtable" style="width:100px; text-align:right; font: 6px courier"></div>

</body>
</html>
Logged Return to Top

Woman, open the door, don't let it sting. I wanna breathe that fire again.
gleek
Flak Jacket

Karma: 107
Posts: 9510
Offline Offline

E chu ta!

View ProfileIgnore this user
Re: Decimal Chart?
« Reply #14 on: January 20, 2008, 11:07:04 AM »

Alternatively, you can test it out on this page:

http://www.w3schools.com/....asp?filename=trycss_font

Copy the text posted above into the left box (overwriting the existing contents). Then click the button above the box to run it.
Logged Return to Top

Woman, open the door, don't let it sting. I wanna breathe that fire again.
Pages: [1] 2 3   Return to Top
  Print  
 
Jump to:  

Related Posts
GOLFHOS NHL PLAYOFFS BRACKET CONTEST
Eastern Conference 7:00 pm W-LPittsburgh 0-0-0Ottawa 0-0-0Pittsburgh: Roster | D
by Aske

Trivia by number
Then don't use a DECIMAL point!!!
by gleek

FBI probing the mortgage industry
6-month charts for two companies that insure asset-backed securities created fro
by gleek

Trivia by number
Then don't use a DECIMAL point!!!LOL.  but didn't you notice it w
by Aske

 


 
  Powered by SMF | SMF © 2001-2009, Lewis Media

Dilber MC Theme by HarzeM