Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jnkell
 
Posts: n/a
Default 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO

when typing a credit card number with 16 digits the last digit always returns
as a zero. Is there a way around this.
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

You will have to format it as text. Excel only supports 15 signifcant
figures. (Many computer programs have this limitation.)
Try formatting the cells as text before you type the numbers in.

tj


"jnkell" wrote:

when typing a credit card number with 16 digits the last digit always returns
as a zero. Is there a way around this.

  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
and another option would be to precede your entry with an apostrophe. e.g.
'1234567890123456

--
Regards
Frank Kabel
Frankfurt, Germany

jnkell wrote:
when typing a credit card number with 16 digits the last digit always
returns as a zero. Is there a way around this.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re What is the formula for adding multiple numbers in a cell merlin_au Excel Discussion (Misc queries) 2 January 4th 05 12:50 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 05:55 PM
Counting multiple numbers in one cell clubin Excel Worksheet Functions 6 December 8th 04 03:47 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM
combining several individual cells of numbers into one cell Jeanne Excel Worksheet Functions 5 November 24th 04 01:31 PM


All times are GMT +1. The time now is 02:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"