Re: $$Excel-Macros$$ 16th digit show zero in excel

2018-07-04 Thread 'GENIUS UFO' via MS EXCEL AND VBA MACROS
use the following format On Friday, June 29, 2018, 2:52:10 PM GMT+5, Ali Abbas wrote: Dear All, when I entered 16th digit in excel excel automatically shows it zero. I need enter 16 or 17 digit in single cell. Plz guide how to fix this issue.  -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ 16th digit show zero in excel

2018-06-29 Thread Kishore P V K
Format the cell or column as text, it will accept without zeros On Friday, June 29, 2018, Ali Abbas wrote: > Dear All, when I entered 16th digit in excel excel automatically shows it >> zero. I need enter 16 or 17 digit in single cell. Plz guide how to fix this >> issue. > > -- > Are you

$$Excel-Macros$$ 16th digit show zero in excel

2018-06-29 Thread Ali Abbas
> > Dear All, when I entered 16th digit in excel excel automatically shows it > zero. I need enter 16 or 17 digit in single cell. Plz guide how to fix this > issue. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of