Number format for cells

B

bgscoop

I need to enter full credit card numbers into an excel sheet that is
created to keep track of transactions. I need to see only the last 4
digits, though.
Tried many things so i hope you guys can help me figure this one out.
 
B

Bondi

bgscoop said:
I need to enter full credit card numbers into an excel sheet that is
created to keep track of transactions. I need to see only the last 4
digits, though.
Tried many things so i hope you guys can help me figure this one out.
Click to expand...

Hi,

Maybe you can enter the full creditcard number in a cell formated as
Text. Then take out the last 4 digites with something like:

=--RIGHT(A1,4)

Regards,
Bondi
 
B

bgscoop

Hi,

Maybe you can enter the full creditcard number in a cell formated as
Text. Then take out the last 4 digites with something like:

=--RIGHT(A1,4)

Regards,
Bondi
Click to expand...


i tried entering only right(a1,4) at first to see how it worked
in the cell it displayed ' #name? ' (without the apostrophies)
any idea how to get through this ?
 
V

VBA Noob

It might be better to use a Input box via VBA.

If you want to continue with a formula then change the font colour o
the ccell your entering the no. to white and enter this formula in th
next cell

=REPT("#",LEN(B2)-4)&RIGHT(B2,4)

VBA Noo
 
V

VBA Noob

You can't put the text and forumla in one cell.

Need to be No in A1 and Formula in B1
 
B

Bondi

bgscoop said:
i tried entering only right(a1,4) at first to see how it worked
in the cell it displayed ' #name? ' (without the apostrophies)
any idea how to get through this ?
Click to expand...
Hi,

The #Name error usualy comes when Excel is not recognizing the formula.
Are you using a English version of Excel?

The common problem when entering credit card numbers is that they are
16 digits and Excel will only take 15. That is why the Formatting as
Text is necessary.

Regards,
Bondi
 
B

bgscoop

VBA said:
You can't put the text and forumla in one cell.

Need to be No in A1 and Formula in B1
Click to expand...


It looks like i wasn't very clear about that :)
i know i can't put them together and i haven't it just seems so from
the way i wrote it
VBA Noob your way worked like a charm thks a lot
now i got another column with the hiden cc numbers and i just gotta
find a way to erase the columns with the full cc numbers.
 
Top