Ask Experts Questions for FREE Help !
Ask
    durgAparna's Avatar
    durgAparna Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jun 26, 2008, 11:19 PM
    In Excel
    I have a problem in excel that is I am unable to enter the number in excel more than 15 digits in Number format. If I tried it's appearing as zeros after 16th digit.



    Ex: - 1234567890123456789 try this number in excel.



    Note: Number should be in Number format only.

    >Moved from Intros<
    lengkyx's Avatar
    lengkyx Posts: 67, Reputation: 3
    Junior Member
    		  
    #2

    Jun 27, 2008, 06:11 PM
    Go to format>cells. Go to number and then check the box for Use 1000 separator (,)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Ms excel [ 4 Answers ]

Hi, Say I have multiple data in a spread sheet like, A 1 DAD111 2 CATUS25 3 58UTIOPS

Ms excel [ 1 Answers ]

Can you give me the meaning of cell adverg

MS Excel [ 2 Answers ]

I am modifying a payroll spreadsheet that was developed in MS Excel. The hours worked by each employee have their own row; each cell represents the hours worked on that particular day. I need to isolate ONLY the amount greater than eight hours (for overtime) and sum those quantities at the end of...

How to get better with Excel [ 2 Answers ]

My Vietnamese staff and I use Excel all the time, but we're limited to very basic stuff. Can anyone recommend an easy and comprehensive how-to reference, either book form (which we would have to order by mail) or on-line info? Thanks. -- Chuck Searcy, Hanoi

Excel help [ 1 Answers ]

I am using excel to record some data and I have it setup to do some math based on the info that I put into certain cells. Now what I am wondering is am I able to setup the sheet so that it will prompt me for the 4 pieces of data that I want to enter and then place those in the proper cells and then...

View more questions Search