Microsoft Excel 2003

G

Guest

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
 
J

Joseph Meehan

becky said:
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

Sorry. This is the Microsoft Access Database newsgroup. It appears
your question is not related to that database. You are much more likely to
find someone with the answer if you post your question to a newsgroup
devoted to your subject.
 
R

Rob Diamant

Joseph,

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

Thanks
 
B

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

Guest

Joseph

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

bb
 
G

Guest

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
 
J

Joseph Meehan

Rob said:
Joseph,

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

Thanks

26 Counties in the Republic of Ireland and 6 counties in North Ireland.
Together they make one nation and one island.
 
J

Joseph Meehan

becky said:
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

Try:


microsoft.public.excel.misc
 
J

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]
 

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