Microsoft Excel 2003

[becky]

I have created a custom format that will let me enter a credit card number on
a form used here at our company. this is an example of how it should look
9999 9999 9999 9999. However, every time I enter a number the final digit
is changed to a 0. It is not rounding. It simply changes to a zero. Can
anyone tell me how to make correct the formatting so that this will stop?

Thanks

 

[Rob Diamant]

Joseph,

Can you please explain your "Irish Math". My wife is Irish and she doesn't
understand either.

Thanks

 

[Brendan Reynolds]

There are a total of 32 counties in the island of Ireland, 26 in the
Republic, 6 in Northern Ireland. Joseph's signature line expresses an
aspiration for a united Ireland.

While Joseph is, of course, entitled to hold and to express his opinion, I
should say that the question of Irish unity is a very complex and sensitive
issue that has cost thousands of lives in the last three decades alone. I
personally find the statement 'It's Irish math' offensive. I'm Irish, and
this is not my math.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[becky]

Joseph

I would love to know this one as well. Never heard of "Irish Math" and I
have Irish blood.

bb

 

[becky]

I had a hard time finding this website. Do you have any suggestions as to
where I could go to find a newsgroup that is devote to my subject?

bb

 

[Rosco]

Becky,
Try http://support.microsoft.com/newsgroups/default.aspx
And navigate through English/Office/Excel, and you will find many different
Excel groups.
Hope this helps
Rosco

 

[John Vinson]

I had a hard time finding this website. Do you have any suggestions as to
where I could go to find a newsgroup that is devote to my subject?

This is the right *website* - but there are over a thousand different
newsgroups on different subjects on this website. Scroll down the list
of Office newsgroups until you find one for Excel. You're apparently
just opening the top one in alphabetical order, which happens to be
microsoft.public.access.

Or, use the News option in Outlook Express; select
msnews.microsoft.com as your news server, and find the
microsoft.public.excel newsgroups in the list.

John W. Vinson[MVP]