Menu

last digit in string gets changed to 0 (16 characters long)

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Ron Rosenfeld

Posts: n/a

Default

On Wed, 29 Jun 2005 06:50:03 -0700, "Mike Milmoe" <Mike
wrote:

trying to enter 16 digit number for credit card. Last digit keeps changing
to "0"

Enter it as text. Either precede the entry with a single quote (') or
pre-format the cell as text.

See HELP for Specifications:

Number precision is limited to 15 digits (as is the case for almost all
spreadsheets)

--ron

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Return a digit in a string of numbers	W M	Excel Discussion (Misc queries)	5	May 11th 05 06:51 PM
Mod-10 Check Digit	Union70	Excel Worksheet Functions	4	March 8th 05 07:58 AM
How to find if a string starts with a digit	galsaba	Excel Worksheet Functions	1	March 4th 05 06:01 PM
Tell users how to sort 5 digit and 9 digit zipcodes correctly aft.	[email protected]	New Users to Excel	1	February 18th 05 12:59 AM
Read Text File into Excel Using VBA	Willie T	Excel Discussion (Misc queries)	13	January 8th 05 12:37 AM

All times are GMT +1. The time now is 02:22 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement