Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to restrict zeros in a number from 16th digit onwards
How to restrict zeros in a number from 16th digit onwards.
In other wards I made cell format as "Number" with no decimals. I entered a number in that particular cell with 1234567891234567 (16 digit number) after enter key it converting as 1234567891234560 ( "0" at 16 digit) Advanced Thanks, Regards, Vinod |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to restrict zeros in a number from 16th digit onwards
Excel will only display 15 digits of a number, and will set any others
to zero. To overcome this you have to enter the number as text - either by pre-formatting the cell as Text, or by typing an apostrophe in front of your number. Hope this helps. Pete On Nov 16, 7:58 pm, Vinod wrote: How to restrict zeros in a number from 16th digit onwards. In other wards I made cell format as "Number" with no decimals. I entered a number in that particular cell with 1234567891234567 (16 digit number) after enter key it converting as 1234567891234560 ( "0" at 16 digit) Advanced Thanks, Regards, Vinod |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to restrict zeros in a number from 16th digit onwards
Excel keeps track of 15 significant digits.
If you need more, you can treat the value as text by: 1. Precede the entry with an apostrophe: '1234123412341234 2. Pre-format the range as Text, then do the data entry. Vinod wrote: How to restrict zeros in a number from 16th digit onwards. In other wards I made cell format as "Number" with no decimals. I entered a number in that particular cell with 1234567891234567 (16 digit number) after enter key it converting as 1234567891234560 ( "0" at 16 digit) Advanced Thanks, Regards, Vinod -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to restrict zeros in a number from 16th digit onwards
Precede the number with a single quote
OR Pre-format the cells as text You will not be able to do arithmetic on these values but I doubt they are real numbers. Excel has a 15 digit precision limit. best wishes -- Bernard Liengme www.stfx.ca/people/bliengme Microsoft Excel MVP remove CAPS in email address "Vinod" wrote in message ... How to restrict zeros in a number from 16th digit onwards. In other wards I made cell format as "Number" with no decimals. I entered a number in that particular cell with 1234567891234567 (16 digit number) after enter key it converting as 1234567891234560 ( "0" at 16 digit) Advanced Thanks, Regards, Vinod |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to restrict zeros in a number from 16th digit onwards
But I wanted to do some arthmatic operations on that number. So, I can't make
it as Text. So is there any other solution. Regards, Vinod "Bernard Liengme" wrote: Precede the number with a single quote OR Pre-format the cells as text You will not be able to do arithmetic on these values but I doubt they are real numbers. Excel has a 15 digit precision limit. best wishes -- Bernard Liengme www.stfx.ca/people/bliengme Microsoft Excel MVP remove CAPS in email address "Vinod" wrote in message ... How to restrict zeros in a number from 16th digit onwards. In other wards I made cell format as "Number" with no decimals. I entered a number in that particular cell with 1234567891234567 (16 digit number) after enter key it converting as 1234567891234560 ( "0" at 16 digit) Advanced Thanks, Regards, Vinod |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to restrict zeros in a number from 16th digit onwards
If you want to do arithmetic on it, you'll have to use text functions such
as LEFT and RIGHT to split it into parts that are within Excel's number range and manipulate them separately. -- David Biddulph "Vinod" wrote in message ... But I wanted to do some arthmatic operations on that number. So, I can't make it as Text. So is there any other solution. Regards, Vinod "Bernard Liengme" wrote: Precede the number with a single quote OR Pre-format the cells as text You will not be able to do arithmetic on these values but I doubt they are real numbers. Excel has a 15 digit precision limit. best wishes -- Bernard Liengme www.stfx.ca/people/bliengme Microsoft Excel MVP remove CAPS in email address "Vinod" wrote in message ... How to restrict zeros in a number from 16th digit onwards. In other wards I made cell format as "Number" with no decimals. I entered a number in that particular cell with 1234567891234567 (16 digit number) after enter key it converting as 1234567891234560 ( "0" at 16 digit) Advanced Thanks, Regards, Vinod |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
16th digit in the cell changes to a zero?? | Excel Discussion (Misc queries) | |||
16th digit changes?? Problem,16th digit changes to a zero.... | Excel Worksheet Functions | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |