Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Gary''s wrote on Tue, 16 Oct 2007 07:21:00 -0700:
GsS You have two options: GsS 1. format the cells as Text before entering the values GsS 2. enter an apostrophe as the first character typed You might have emphasized that both options produce text ;-) ?? When I try to put a string of 18 digits in a column ?? (similar to this 350001660334434123) the last three digits ?? change to 000 (making the number 350001660334434000), I ?? have change the column to format in 'General' but this ?? throws up an error message and nothing else seems to give ?? me what I need. Any help would be appreciated. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions | |||
Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
How do I identify the 7th digit in a 13 digit number, then establi | Excel Worksheet Functions | |||
Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |