Number of Digits in a Cell

  • Thread starter Thread starter Ric Larson
  • Start date Start date
R

Ric Larson

When I enter a credit card number of 16 digits, the last digit always
displays as 0 (zero). Does MS limit the number of digits to 15, or is there
a way I can allow all 16 digits to display correctly? I have tried custom
number formatting using #### #### #### #### and 0000000000000000, but it
does not work. The only way I have been able to do it is by inputting the
number using spaces between each set of 4 digits. Since I want to copy and
paste to Quickbooks, this is counterproductive. Any thoughts?
 
Format the cell as TEXT, *before* you enter any data,
OR
Enter an apostrophe (') first, which will not show in the cell.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

When I enter a credit card number of 16 digits, the last digit always
displays as 0 (zero). Does MS limit the number of digits to 15, or is there
a way I can allow all 16 digits to display correctly? I have tried custom
number formatting using #### #### #### #### and 0000000000000000, but it
does not work. The only way I have been able to do it is by inputting the
number using spaces between each set of 4 digits. Since I want to copy and
paste to Quickbooks, this is counterproductive. Any thoughts?
 
Manish,

NO ?... NO to what ?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

No, but this will not help in filtering a range by
dragging below. Therefore, suggest that break your 16
digit no. into two parts of 11 digits & 5 digits and,
then, drag them to fill a range ( hope 11 digit will
remain same and 5 digit will keep increasing by 1) do a
concatenate of these two into a new column. This new col.
will show you all the 16 digits correctly without
converting the last digit as zero !

Thanks & regards,

Manish
 
Sorry RD. I didn't mean to disagree with your solution.
That works fine if you have to key in the no. on every
cell, but, it will be time consuming if you have to enter
a series of nos. continuously as if you drag it down, the
nos. won't increase by 1.

Regret for inconvenience,

Manish
 
The OP did mention credit card numbers.

I highly doubt if they are in any sort of numerical order ... except of
course if he works for the originating credit card company.<g>
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Sorry RD. I didn't mean to disagree with your solution.
That works fine if you have to key in the no. on every
cell, but, it will be time consuming if you have to enter
a series of nos. continuously as if you drag it down, the
nos. won't increase by 1.

Regret for inconvenience,

Manish
 
All suggestions so far have been very good for us Excel types, but my target
audience is different.

Let me be more specific. I am building a spreadsheet for salespeople to
enter credit card information for their sales, which then gets emailed to me
for entry into Quickbooks. The last thing they want to do is concantenate.
My solution needs to be monkey-proof. Each entry is random, all I want to be
able to do is display correctly and be able to copy and paste to save me
valuable time.
 
Let me be more specific. I am building a spreadsheet for salespeople to
enter credit card information for their sales, which then gets emailed to me
for entry into Quickbooks. The last thing they want to do is concantenate.
My solution needs to be monkey-proof. Each entry is random, all I want to be
able to do is display correctly and be able to copy and paste to save me
valuable time.
Click to expand...

Ensure that the cells are formatted as text, prior to the salespeople making
their entries.


--ron
 
Did your newsreader program not display my first answer to your question ?

<"Format the cell as TEXT, *before* you enter any data,
OR
Enter an apostrophe (') first, which will not show in the cell.">

What could be more "Monkey-Proof" then *YOU* formatting the cells as Text
when you build the sheet ?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


All suggestions so far have been very good for us Excel types, but my target
audience is different.

Let me be more specific. I am building a spreadsheet for salespeople to
enter credit card information for their sales, which then gets emailed to me
for entry into Quickbooks. The last thing they want to do is concantenate.
My solution needs to be monkey-proof. Each entry is random, all I want to be
able to do is display correctly and be able to copy and paste to save me
valuable time.
 
RD:

The simple, obvious solution always seems to elude me. Your suggestion
worked. I should have tried it in the first place.

Thanks.

RTL
 
Back
Top