moves number two decimal places

> In article ,
> brentcook.TakeThisOut@officeformac.com wrote:
>
> > 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.
>

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.

In article <59b6177e.1.DeleteThis@webcrossing.caR9absDaxw>,
brentcook.DeleteThis@officeformac.com wrote:

> 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.

In article <jemcgimpsey-AC0E9E.10255811112008.TakeThisOut@news.microsoft.com>,
JE McGimpsey <jemcgimpsey.TakeThisOut@mvps.org> wrote:

> In article <59b6177e.-1.TakeThisOut@webcrossing.caR9absDaxw>,
> brentcook.TakeThisOut@officeformac.com wrote:
>
> > 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.

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.

--
Team EM to the rescue! http://www.team-em.com

In article <carl-F3E966.19305211112008.DeleteThis@web.aioe.org>,
Carl Witthoft <carl.DeleteThis@witthoft.com> wrote:

> 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?

> In article ,
> brentcook DeleteThis @officeformac.com wrote:
Thanks, this was the problem and I switched as you suggested. All is well.
B
>
> > 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.
>

In article <jemcgimpsey-532AAE.21122711112008 DeleteThis @news.microsoft.com>,
JE McGimpsey <jemcgimpsey DeleteThis @mvps.org> wrote:

> In article <carl-F3E966.19305211112008 DeleteThis @web.aioe.org>,
> Carl Witthoft <carl DeleteThis @witthoft.com> wrote:
>
> > 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?

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.

--
Team EM to the rescue! http://www.team-em.com

In article <carl-29CA3E.17583912112008 RemoveThis @web.aioe.org>,
Carl Witthoft <carl RemoveThis @witthoft.com> wrote:

> 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.

<It's not a user-modifiable setting>

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JE McGimpsey" <jemcgimpsey DeleteThis @mvps.org> wrote in message
news:jemcgimpsey-1D0CCC.15091813112008@news.microsoft.com...
> In article <carl-29CA3E.17583912112008 DeleteThis @web.aioe.org>,
> Carl Witthoft <carl DeleteThis @witthoft.com> wrote:
>
>> 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.

In article <545481EC-7C5A-40D3-B8CD-9763810BD0C4.TakeThisOut@microsoft.com>,
"Niek Otten" <nicolaus.TakeThisOut@xs4all.nl> wrote:

> <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.

OK, Thanks for the info, John!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JE McGimpsey" <jemcgimpsey.TakeThisOut@mvps.org> wrote in message
news:jemcgimpsey-FA6A6D.10210614112008@news.microsoft.com...
> In article <545481EC-7C5A-40D3-B8CD-9763810BD0C4.TakeThisOut@microsoft.com>,
> "Niek Otten" <nicolaus.TakeThisOut@xs4all.nl> wrote:
>
>> <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.

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 McGimpsey wrote:
> In article <545481EC-7C5A-40D3-B8CD-9763810BD0C4.RemoveThis@microsoft.com>,
> "Niek Otten" <nicolaus.RemoveThis@xs4all.nl> wrote:
>
>> <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.

--
------------------------------------------------------------------------
Phillip M. Jones, CET mailto:pjones@kimbanet.com
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
------------------------------------------------------------------------

olVX0A jzisnqlnpnva <http://jzisnqlnpnva.com/>, [url=http://movzvbrvfjml.com/]movzvbrvfjml[/url], [link=http://pildtamdaqvv.com/]pildtamdaqvv[/link], <http://tgecogqwycgj.com/>

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,