stroh
Sleeveless Hoodie From: Impact Crater Springs, CA
Karma: 155 Posts: 16135
OfflineWe're doomed!
|
|
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!
|
|
|
Logged
|
|
|
|
Aske
Lederhosen
Karma: 120 Posts: 31405
Offline
|
|
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
|
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
|
|
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.
|
|
|
Logged
|
"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
OfflineWe're doomed!
|
|
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
|
|
|
|
gleek
Flak Jacket
Karma: 107 Posts: 9511
OfflineE chu ta!
|
|
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
|
Woman, open the door, don't let it sting. I wanna breathe that fire again.
|
|
|
gleek
Flak Jacket
Karma: 107 Posts: 9511
OfflineE chu ta!
|
|
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.
|
|
|
Logged
|
Woman, open the door, don't let it sting. I wanna breathe that fire again.
|
|
|
Seamus
Straitjacket
Karma: 52 Posts: 2376
OfflineI'm a juvenile acting product of the working class
|
|
Re: Decimal Chart?
« Reply #6 on: January 20, 2008, 09:53:57 AM » |
|
What's a decimal chart? Everything you need is right in here.
|
|
|
Logged
|
|
|
|
stroh
Sleeveless Hoodie From: Impact Crater Springs, CA
Karma: 155 Posts: 16135
OfflineWe're doomed!
|
|
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.
|
|
|
Logged
|
|
|
|
stroh
Sleeveless Hoodie From: Impact Crater Springs, CA
Karma: 155 Posts: 16135
OfflineWe're doomed!
|
|
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
|
|
|
|
spacey
Amazing Technicolor Dreamcoat From: Group W Bench
Karma: 98 Posts: 7733
Offline
|
|
Re: Decimal Chart?
« Reply #9 on: January 20, 2008, 10:44:04 AM » |
|
Like this?
|
|
|
Logged
|
|
|
|
stroh
Sleeveless Hoodie From: Impact Crater Springs, CA
Karma: 155 Posts: 16135
OfflineWe're doomed!
|
|
Re: Decimal Chart?
« Reply #10 on: January 20, 2008, 10:58:45 AM » |
|
Like this?
Can't open it. I wonder if that's the problem. I don't have Excel? I guess I just have "MS Works Spreadsheet" ?
|
|
|
Logged
|
|
|
|
Seamus
Straitjacket
Karma: 52 Posts: 2376
OfflineI'm a juvenile acting product of the working class
|
|
Re: Decimal Chart?
« Reply #11 on: January 20, 2008, 11:00:44 AM » |
|
Like this?
Can't open it. 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
|
|
|
|
spacey
Amazing Technicolor Dreamcoat From: Group W Bench
Karma: 98 Posts: 7733
Offline
|
|
Re: Decimal Chart?
« Reply #12 on: January 20, 2008, 11:03:34 AM » |
|
|
|
|
Logged
|
|
|
|
gleek
Flak Jacket
Karma: 107 Posts: 9511
OfflineE chu ta!
|
|
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. <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
|
Woman, open the door, don't let it sting. I wanna breathe that fire again.
|
|
|
gleek
Flak Jacket
Karma: 107 Posts: 9511
OfflineE chu ta!
|
|
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_fontCopy the text posted above into the left box (overwriting the existing contents). Then click the button above the box to run it.
|
|
|
Logged
|
Woman, open the door, don't let it sting. I wanna breathe that fire again.
|
|
|