Tjyylli

Why does John Bercow say “unlock” after reading out the results of a vote?

Is it correct to write "is not focus on"?

Where in the Bible does the greeting ("Dominus Vobiscum") used at Mass come from?

How can I replace every global instance of "x[2]" with "x_2"

Generic lambda vs generic function give different behaviour

Failed to fetch jessie backports repository

Is it okay / does it make sense for another player to join a running game of Munchkin?

How can I get through very long and very dry, but also very useful technical documents when learning a new tool?

The plural of 'stomach"

Was the picture area of a CRT a parallelogram (instead of a true rectangle)?

Hostile work environment after whistle-blowing on coworker and our boss. What do I do?

Is there an Impartial Brexit Deal comparison site?

Is the destination of a commercial flight important for the pilot?

Is a roofing delivery truck likely to crack my driveway slab?

Should my PhD thesis be submitted under my legal name?

Was Spock the First Vulcan in Starfleet?

Bash method for viewing beginning and end of file

Applicability of Single Responsibility Principle

If you attempt to grapple an opponent that you are hidden from, do they roll at disadvantage?

Mapping a list into a phase plot

apt-get update is failing in debian

Why is delta-v is the most useful quantity for planning space travel?

What would happen if the UK refused to take part in EU Parliamentary elections?

What is the oldest known work of fiction?

VBA Excel code to automatically format text (Credit Card Numbers) based on length of string?

Why does Excel treat long numeric strings as scientific notation even after changing cell format to textFormat columns matching drop down value Excel 2003/VBAExcel - Convert dates and currency as text to Excel dates and numbers respectivelyVBA Code De-bugging in 2010 excelHow do I stop Excel from formatting numbers?Excel VBA filter String contains NumbersLocking and unlocking cells based on value in another cell for tablesExcluding text during VBA (Excel) RegEx searchWhy does the code permute delimitersExcel VBA for pulling apart text from a few cells and creating multiple cells of data

0

Background:

1. Number formatted cells in Excel have digits beyond the 15th changed
   to zeros (reason). This behavior affects the recording
   of credit card numbers which can be longer than 15 digits. A work around to this behavior in Excel is to format cells that will contain credit card numbers (in advance of entering the data) as strings instead of numbers.


2. To display this string in a more user-friendly format I add a helper
   column that takes the string and chunks it out.


3. I do this by testing the length of the string and if it is 16
   characters I chunk it out as 4 4 4 4 (Canadian VISA/MC) and if it is 15 digits I chunk it out as 3 6 5 (Canadian Amex).
   Image  1:  Sample of my table        Image  2:  Formula I use to chunk in helper column
   

Question:

Can you adapt my worksheet code for VBA to dynamically apply the desired format to the column containing my credit card strings whenever the data changes? Image  3:  My table after adding requested VBA code

microsoft-excel vba

share|improve this question

asked 11 mins ago

Blind SpotsBlind Spots

11

add a comment | 

0

Background:

1. Number formatted cells in Excel have digits beyond the 15th changed
   to zeros (reason). This behavior affects the recording
   of credit card numbers which can be longer than 15 digits. A work around to this behavior in Excel is to format cells that will contain credit card numbers (in advance of entering the data) as strings instead of numbers.


2. To display this string in a more user-friendly format I add a helper
   column that takes the string and chunks it out.


3. I do this by testing the length of the string and if it is 16
   characters I chunk it out as 4 4 4 4 (Canadian VISA/MC) and if it is 15 digits I chunk it out as 3 6 5 (Canadian Amex).
   Image  1:  Sample of my table        Image  2:  Formula I use to chunk in helper column
   

Question:

Can you adapt my worksheet code for VBA to dynamically apply the desired format to the column containing my credit card strings whenever the data changes? Image  3:  My table after adding requested VBA code

microsoft-excel vba

share|improve this question

asked 11 mins ago

Blind SpotsBlind Spots

11

add a comment | 

Background:

1. Number formatted cells in Excel have digits beyond the 15th changed
   to zeros (reason). This behavior affects the recording
   of credit card numbers which can be longer than 15 digits. A work around to this behavior in Excel is to format cells that will contain credit card numbers (in advance of entering the data) as strings instead of numbers.


2. To display this string in a more user-friendly format I add a helper
   column that takes the string and chunks it out.


3. I do this by testing the length of the string and if it is 16
   characters I chunk it out as 4 4 4 4 (Canadian VISA/MC) and if it is 15 digits I chunk it out as 3 6 5 (Canadian Amex).
   Image  1:  Sample of my table        Image  2:  Formula I use to chunk in helper column
   

Question:

Can you adapt my worksheet code for VBA to dynamically apply the desired format to the column containing my credit card strings whenever the data changes? Image  3:  My table after adding requested VBA code

microsoft-excel vba

share|improve this question

asked 11 mins ago

Blind SpotsBlind Spots

11

share|improve this question

asked 11 mins ago

Blind SpotsBlind Spots

11

share|improve this question

asked 11 mins ago

Blind SpotsBlind Spots

11

asked 11 mins ago

Blind SpotsBlind Spots

11

asked 11 mins ago

Blind SpotsBlind Spots

11