Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
//sk - Max length of a numeric field.
Hi !!
Want to have a series of numbers - 19 digits long. like - 8999876456789650000 The issue is that am unable to mention any no. for the last four digits. It always takes it as 0000 . Why am i unable to change this and is there any way that i can mention any other no. that 0000. ? Rgds //sk. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
//sk - Max length of a numeric field.
Just format the cell as Text and try to enter the value Select the range and do Right Click and select Format CellsNumberCategoryText and give ok. Otherwise before entering the value in a cell type ' and enter your Zero value numbers. If this post helps, Click Yes! -------------------- (MS-Exl-Learner) -------------------- "sansk_23" wrote: Hi !! Want to have a series of numbers - 19 digits long. like - 8999876456789650000 The issue is that am unable to mention any no. for the last four digits. It always takes it as 0000 . Why am i unable to change this and is there any way that i can mention any other no. that 0000. ? Rgds //sk. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
//sk - Max length of a numeric field.
Hi,
Format the cells are text values and then input the numbers in those cells. In this application, one can one enter number upto 15 digits. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "sansk_23" wrote in message ... Hi !! Want to have a series of numbers - 19 digits long. like - 8999876456789650000 The issue is that am unable to mention any no. for the last four digits. It always takes it as 0000 . Why am i unable to change this and is there any way that i can mention any other no. that 0000. ? Rgds //sk. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
//sk - Max length of a numeric field.
Thx.
Further to this, wanted to check as to how can i check any duplicates on the text field - In case there is any no. getting repeated more than once... Rgds/ /sk. "Ashish Mathur" wrote: Hi, Format the cells are text values and then input the numbers in those cells. In this application, one can one enter number upto 15 digits. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "sansk_23" wrote in message ... Hi !! Want to have a series of numbers - 19 digits long. like - 8999876456789650000 The issue is that am unable to mention any no. for the last four digits. It always takes it as 0000 . Why am i unable to change this and is there any way that i can mention any other no. that 0000. ? Rgds //sk. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
//sk - Max length of a numeric field.
Try this function€¦
=COUNTIF(A:A,A1) Here I have mentioned the range as A:A change it to your desired Column. Assume that if your data is present in column D then change it to D:D and in the same way change the criteria A1 to your desired cell. In this example it should be marked as D1. After applying this function just copy and paste it to the remaining cells. If this post helps, Click Yes€¦ -------------------- (Ms-Exl-Learner) -------------------- "sansk_23" wrote: Thx. Further to this, wanted to check as to how can i check any duplicates on the text field - In case there is any no. getting repeated more than once... Rgds/ /sk. "Ashish Mathur" wrote: Hi, Format the cells are text values and then input the numbers in those cells. In this application, one can one enter number upto 15 digits. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "sansk_23" wrote in message ... Hi !! Want to have a series of numbers - 19 digits long. like - 8999876456789650000 The issue is that am unable to mention any no. for the last four digits. It always takes it as 0000 . Why am i unable to change this and is there any way that i can mention any other no. that 0000. ? Rgds //sk. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Field Validation for Length & Character Type | Excel Discussion (Misc queries) | |||
Pad field length | Excel Discussion (Misc queries) | |||
Merge an alpha field and a numeric field | Excel Discussion (Misc queries) | |||
Field length of VBA totals in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I fix a field length? | Excel Discussion (Misc queries) |