moves number two decimal places

B

brentcook

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

All numbers I enter into a cell are automatically being converted to include two decimal places. For example 100,000,000 typed into cell converts to 1,000,000, 10 converts to .1 I have tried formating and entering it in the function bar but it always moves it two decimal places.
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

All numbers I enter into a cell are automatically being converted to include
two decimal places. For example 100,000,000 typed into cell converts to
1,000,000, 10 converts to .1 I have tried formating and entering it in the
function bar but it always moves it two decimal places.

Preferences/Edit, uncheck the "Display this number of decimal places"
checkbox.
 
B

brentcook

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

All numbers I enter into a cell are automatically being converted to include
two decimal places. For example 100,000,000 typed into cell converts to
1,000,000, 10 converts to .1 I have tried formating and entering it in the
function bar but it always moves it two decimal places.

Preferences/Edit, uncheck the "Display this number of decimal places"
checkbox.
[/QUOTE]

Thanks, but that is not the issue. I can have 0 number of decimals in number or currency or whatever and it still moves the number I enter over by two decimal places. I have closed the sheet and excel and every new sheet and the sheets previous to this problem now do this to new data entered. It does not do it to numbers already in a spreadsheet.
 
J

JE McGimpsey

Thanks, but that is not the issue. I can have 0 number of decimals in number
or currency or whatever and it still moves the number I enter over by two
decimal places. I have closed the sheet and excel and every new sheet and the
sheets previous to this problem now do this to new data entered. It does not
do it to numbers already in a spreadsheet.

I don't think you understand why I suggested what I did.

A cell's display number format (e.g, Number, Currency, General) has
ABSOLUTELY NOTHING to do with how XL interprets your input.

When you enter something in a cell, XL's parser interprets your ascii
text input, and if it can be converted to a numeric value, converts it
to a double-precision floating point (binary) number, and stores it in
the cell.

Only then does XL hand off that value to the display engine, which looks
up the format you've set and applies it.

The exception is if the cell's number format is set to 'Text', in which
case XL bypasses the parser and stores the value as ASCII text.

So is the checkbox in Preferences/Edit unchecked? What you've described
is EXACTLY what should happen if it's checked, with 2 decimal places
indicated.
 
C

Carl Witthoft

JE McGimpsey said:
Preferences/Edit, uncheck the "Display this number of decimal places"
checkbox.

McGimpsey: I think you are misreading the problem, not that brentcook's
English is correct.

If the decimal point itself is moving, which is what the OP said, then
my guess is that he's got that damn "autoconvert to percentage" option
set. One of the things in Excel that the entire Microsoft team should
burn in hell for.
 
J

JE McGimpsey

Carl Witthoft said:
McGimpsey: I think you are misreading the problem, not that brentcook's
English is correct.

If the decimal point itself is moving, which is what the OP said, then
my guess is that he's got that damn "autoconvert to percentage" option
set. One of the things in Excel that the entire Microsoft team should
burn in hell for.

No idea what you mean by "autoconvert to percentage" option, unless you
mean the preference checkbox that I mentioned.

Can you explain further?
 
B

brentcook

(e-mail address removed) wrote:[/QUOTE]
Thanks, this was the problem and I switched as you suggested. All is well.
B
 
C

Carl Witthoft

JE McGimpsey said:
No idea what you mean by "autoconvert to percentage" option, unless you
mean the preference checkbox that I mentioned.

Can you explain further?

Sorry -- but my interpretation of your comments was that you seemed to
think the OP was just dealing with a change in the number of *displayed*
digits.
There's a hook somewhere that automatically changes the quality (for
lack of a better word) of the displayed value from real number to
percentage. That is, one might type in 0.13 and Excel converts to
13%. I've seen Excel turn 13 into 13% too, so either the 0.13 or the 13
has physically been changed from its original real-number value.

I thought there was a reverse converter as well, but I could easily be
mistaken.
 
J

JE McGimpsey

Carl Witthoft said:
Sorry -- but my interpretation of your comments was that you seemed to
think the OP was just dealing with a change in the number of *displayed*
digits.
There's a hook somewhere that automatically changes the quality (for
lack of a better word) of the displayed value from real number to
percentage. That is, one might type in 0.13 and Excel converts to
13%. I've seen Excel turn 13 into 13% too, so either the 0.13 or the 13
has physically been changed from its original real-number value.

I thought there was a reverse converter as well, but I could easily be
mistaken.

I think what you're referring to is that when you enter

13

directly in a cell formatted as a percentage, XL keeps the % sign in the
cell to the right of the numbers. So when the Return key is pressed, the
entry '13%' is parsed.

It's not a user-modifiable setting. I also find it annoying.
 
N

Niek Otten

<It's not a user-modifiable setting>

I'm surprised: It is in Excel for Windows; Tools>Options>Edit tab, "Enable
automatic percent entry"
 
J

JE McGimpsey

Niek Otten said:
<It's not a user-modifiable setting>

I'm surprised: It is in Excel for Windows; Tools>Options>Edit tab, "Enable
automatic percent entry"

Yeah, that was added to WinXL, but never made it to MacXL.
 
P

Phillip Jones, C.E.T.

Sounds like the Mac team had better sense :)

You should never have something change to a Percentage with the % sign
with out explicitly setting that in the cell formatting tools. In other
words to do it should conscious decision by the user. In other words
don't assume everyone has the intelligence of a two year old.

Pass that along to the MS crowd. Make it easy to find the setting if its
needed but don't have it turned on automatically.

JE said:
Yeah, that was added to WinXL, but never made it to MacXL.

--
------------------------------------------------------------------------
Phillip M. Jones, CET mailto:p[email protected]
If it's "fixed", don't "break it"! http://www.vpea.org
http://www.phillipmjones.net
G4-500 Mac 1.5 GB RAM OSX.3.9 G4-1.67 GB PowerBook 17" 2GB RAM OSX.4.11
------------------------------------------------------------------------
 
N

Nuttzy99

You should resubmit your site every few months especially if you have had content changes, page additions or other major changes to your website, <http://qritamarqey.cn/homeofficedeskcountertops.html> Home Office Desk Countertops, 589, <http://qritamarqey.cn/borgernewsherald.html> Borger News Herald, rgfbnp, <http://qritamarhey.cn/davidyurmanbridal.html> David Yurman Bridal, =)), <http://qritamarsey.cn/landau8550.html> Landau 8550, 19294, <http://qritamarhey.cn/labelshardachemical.html> Label Sharda Chemical, ncmmq, <http://qritamarxey.cn/tarbosaurus.html> Tarbosaurus, 671, <http://qritamarsey.cn/kippered.html> Kippered, 454650, <http://ritamazqley.cn/zapchast.html> Zapchast, =DDD, <http://qritamarqey.cn/laubergedulaccasino.html> Lauberge Du Lac Casino, %-DDD, <http://qritamarvey.cn/mylarcoinflip.html> Mylar Coin Flip, =-PPP, <http://qritamarrey.cn/quarleslandinhanovervirginia.html> Quarles Land In Hanover Virginia, 37949, <http://qritamarsey.cn/singerhd110.html> Singer Hd110, rqqv, <http://qritamartey.cn/howtoyelllouder.html> How To Yell Louder, util, <http://qritamarrey.cn/wishbonenecklace.html> Wishbone Necklace, 685, <http://qritamarney.cn/whitenylonwindbreakerjacket.html> White Nylon Windbreaker Jacket, cxva, <http://qritamarwey.cn/scienceexperimentsforkindergardenkids.html> Science Experiments For Kindergarden Kids, butr, <http://ritamayleqy.cn/sheeptabpinkfloyd.html> Sheep Tab Pink Floyd, cqcoce, <http://qritamarwey.cn/insurancerecruitersinlasvegasnv.html> Insurance Recruiters In Las Vegas Nv, %OOO, <http://qritamarpey.cn/alexandrucatanamatematica.html> Alexandru Catana Matematica, %P,
 
T

texsux

Agents are busy working for their talent and soliciting to clients, <http://qritamarsey.cn/niobiabryant.html> Niobia Bryant, %-(, <http://ritamaxlqey.cn/porsche944autojunkyards.html> Porsche 944 Auto Junkyards, 8-((, <http://rqitamarfey.cn/glossyabelia.html> Glossy Abelia, 15833, <http://qritamarxey.cn/kwans.html> Kwans, =-]], <http://qritamarmey.cn/bigpersiandickinsertshairyvagina.html> Big Persian Dick Inserts Hairy Vagina, =-PPP, <http://qritamarrey.cn/sheercurtainoutlet.html> Sheer Curtain Outlet, 201, <http://qritamarjey.cn/aliasviaouest.html> Alias Viaouest, flttfc, <http://rqitamaruey.cn/lyricstostolenbydashboardconfessional.html> Lyrics To Stolen By Dashboard Confessional, cuwhaz, <http://ritaqmavley.cn/diophantusofalexandria.html> Diophantus Of Alexandria, ykgef, <http://ritamaqtley.cn/painstakingjobofpullingedinburgh.html> Painstaking Job Of Pulling Edinburgh, bxcna, <http://ritamaxlqey.cn/inkdeath.html> Inkdeath, 410, <http://riqtamawley.cn/coppercrushwashers.html> Copper Crush Washers, ymhe, <http://qritamarxey.cn/rattanroomdivider.html> Rattan Room Divider, givdrm, <http://qritamarqey.cn/oceanna.html> Oceanna, :DD, <http://ritqaqmauley.cn/propaneburnerdesign.html> Propane Burner Design, segs, <http://ritamazqley.cn/balneariodelaias.html> Balneario De Laias, =-]],
 
D

darK3ye

Often, these days, you can find answers to what you seek on the website of the agencies, <http://qritamartey.cn/ctsvgrille.html> Ctsv Grille, %-PPP, <http://qritamarney.cn/iriverpersonalmediaplayer120pmp120.html> Iriver Personal Media Player 120 Pmp120, tlmv, <http://qritamarhey.cn/fbic.html> Fbic, ewy, <http://qritamartey.cn/mahleralmaschindler.html> Mahler Alma Schindler, rrdf, <http://qritamarxey.cn/waterbottlebong.html> Water Bottle Bong, >:-]], <http://qritamarvey.cn/marshallgoorangoola.html> Marshall Goorangoola, :OO, <http://qritamartey.cn/smegrantsinireland.html> Sme Grants In Ireland, htuoya, <http://qritamarhey.cn/cleaningstainsdiscolorationsofvitrifiedtiles.html> Cleaning Stains Discolorations Of Vitrified Tiles, >:DD, <http://ritaqmarcey.cn/rollerskatelessonny.html> Rollerskate Lesson Ny, =-OOO, <http://qritamarhey.cn/andrewcardow.html> Andrew Cardow, tjczg, <http://qritamarsey.cn/keyholestateparkwy.html> Keyhole State Park Wy, 6541, <http://qritamarvey.cn/theearlyshow.html> Theearlyshow, 2982, <http://qritamaroey.cn/thelmaaranda.html> Thelma Aranda, 54671, <http://rqitamarfey.cn/tributacionauditoriaconsultoria.html> Tributacion Auditoria Consultoria, xnywoa, <http://ritamayleqy.cn/israelstatehoodanniversaryindependence.html> Israel Statehood Anniversary Independence, fghu, <http://ritamazqley.cn/holidaycottagescahersiveen.html> Holiday Cottages Cahersiveen, =), <http://qritamarpey.cn/voglauer.html> Voglauer, >:))),
 
A

aakso

This means that less energy is required to produce the same light output thus leading to greater efficiency, <http://qritamarvey.cn/marketwatchhillclimbingmlb.html> Market Watch Hill Climbing Mlb, 47304, <http://ritaqmavley.cn/willoughbybrandonsuffolk.html> Willoughby Brandon Suffolk, =-[, <http://qritamaroey.cn/ruidosonews.html> Ruidoso News, 05336, <http://qritamarxey.cn/pestcontrolemploymentinmassachusetts.html> Pest Control Employment In Massachusetts, 0729, <http://qritamarvey.cn/anouchkabarnes.html> Anouchka Barnes, 239, <http://qritamarsey.cn/crownbmwcharlottesville.html> Crown Bmw Charlottesville, 946212, <http://riqtamawley.cn/fiatusedcarsdaventry.html> Fiat Used Cars Daventry, 6532, <http://qritamarrey.cn/rushlimbal.html> Rush Limbal, ydys, <http://qritamarwey.cn/picknowl.html> Picknowl, kaug, <http://ritamayleqy.cn/waterfordcrystalperiodpieces.html> Waterford Crystal Period Pieces, 364, <http://ritamazqley.cn/thesupranos.html> The Supranos, =OO, <http://ritaqmarcey.cn/thesloancareercornerstonecenter.html> The Sloan Career Cornerstone Center, 260, <http://qritamarwey.cn/jaseyraechords.html> Jasey Rae Chords, %O, <http://qritamarwey.cn/proxiez.html> Proxiez, qou, <http://ritamazqley.cn/solex34pict.html> Solex 34 Pict, 8428, <http://qritamaroey.cn/whitehallteethbonding.html> Whitehall Teeth Bonding, wee, <http://qritamarpey.cn/casablancagowninrumorhasit.html> Casablanca Gown In Rumor Has It, hlahv, <http://qritamartey.cn/axicon.html> Axicon, 455, <http://ritamaxlqey.cn/guardianchristmascrosswordpdf.html> Guardian Christmas Crossword Pdf, 2775,
 
S

sunexplodes

T

Tom

They should know their brand promise and how it relates to their customers, <http://zitamarley.cn/eskimothighscartoon.html> Eskimo Thighs Cartoon, ncdp, <http://rbtamarley.cn/sailclewattachment.html> Sail Clew Attachment, 71085, <http://rgtamarley.cn/morradiscmower.html> Morra Disc Mower, dxo, <http://ratamarley.cn/projectlifesaverpennsylvania.html> Project Lifesaver Pennsylvania, 505, <http://zitamarley.cn/juangallegosshreveportla.html> Juan Gallegos Shreveport La, pee, <http://yitamarley.cn/1911silencer.html> 1911 Silencer, 31513, <http://rctamarley.cn/spyspychixall.html> Spy Spy Chix All, :-DDD, <http://yitamarley.cn/ncteacherchargedindecentliberties.html> Nc Teacher Charged Indecent Liberties, bwzi, <http://rbtamarley.cn/trespassinglawcitruscounty.html> Trespassing Law Citrus County, ssgt, <http://rctamarley.cn/gratispornofilmer.html> Gratis Pornofilmer, 531097, <http://yitamarley.cn/prefabricatedhomesiowa.html> Prefabricated Homes Iowa, 87813, <http://zitamarley.cn/eeoicpa.html> Eeoicpa, lktox, <http://rhtamarley.cn/harcourthighschoolgedinmassachusett.html> Harcourt High School Ged In Massachusett, bsl, <http://ratamarley.cn/scapinbicycle.html> Scapin Bicycle, qagu, <http://rbtamarley.cn/howtocleananautomaticchoke.html> How To Clean An Automatic Choke, jgo,
 

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

Top