Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Credit Card Cell

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hey,

    am making a order form and i have a credit card number cell but i cant get format cell to let me display the data like this:

    4545-676745-5656-78787

    when i format the cell with :

    ####-######-####-#####

    it kills the last 4 digits and makes them all zeros

    any ideas please

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Number are limited to 15 in Excel

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,312
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think you'll want to go with a text format on this one. I believe this is an excel limitation.

    Adam

  4. #4
    Board Regular zacemmel's Avatar
    Join Date
    Apr 2002
    Location
    Redmond, WA
    Posts
    636
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Preface the cell with an apostrophe or format the cells as text before entering the credit card numbers.

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    http://www.mrexcel.com/board/viewtop...c=1855&forum=2

    not an answer to your specific question, but this may be worth bearing in mind as your form develops...
    :: Pharma Z - Family drugstore ::

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    all works fine for me, as many numbers as i like ::::

    also you CC i copy paste and that goes in???

    lost all seem ok to me.. what excel are you running,,,

    and type exactly what result you want...

    ill try again

    just input as text try ' the numbers the ' will disapear/


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •