Problem In Excel...

go4saket · 20-10-2007, 10:13 AM

Hi Guys!

I have a small problem with Excel. If I type a huge number in any cell, say "777777777777777", it automatically gets converted to "7.77778E+14". I dont want this to happen and want it to be displayed normally. How can I stop this from happening.

Chao...

Gigacore · 20-10-2007, 10:18 AM

this is just because the word length or the bit is limited to 16 bits

go4saket · 20-10-2007, 10:26 AM

So does this mean that I cannot use a large number in Excel sheets. BTW, which is the largest number supported by 16 Bits...

Gigacore · 20-10-2007, 10:40 AM

i really dont know. . . but try those numbers in Calculator too you will get the same . . . . you can get more info about 16 bits in wiki

iinfi · 20-10-2007, 12:02 PM

well try this ...

right click on the cell (or range of cells) where u want this number to be displayed..
goto format cells >> number tab >> number option in the list box >> select "0" in decimal places.

click on OK ..

is this wat u want ??

Ramakrishnan · 22-10-2007, 03:04 PM

Just format the cell in number format. If you get ###### like this, increase the width. That is all.

ayush_chh · 23-10-2007, 12:01 AM

guys i too have problem in excel.....

what i want is, to enter a date in one cell and get the date after 30 days in some other cell automatically....how can i do this???

Ramakrishnan · 23-10-2007, 03:02 PM

Quote:

Originally Posted by ayush_chh

guys i too have problem in excel.....

what i want is, to enter a date in one cell and get the date after 30 days in some other cell automatically....how can i do this???

press + and go the cell containing the first date again press + and 30 and enter

Suppose you don't get in date format format in "date"

20-10-2007, 10:13 AM	#1 (permalink)
go4saket 9437077259 Join Date: Sep 2005 Location: Sambalpur, Orissa Posts: 1,252	Problem In Excel... Hi Guys! I have a small problem with Excel. If I type a huge number in any cell, say "777777777777777", it automatically gets converted to "7.77778E+14". I dont want this to happen and want it to be displayed normally. How can I stop this from happening. Chao... __________________ Win 7 Ultimate Abit IP35-E Mobo,C2Q 6600,4GB DDR2 RAM,XFX 8600GT 256MB DDR3 Gfx ,Seagate 1TB HDD,Sony DVD RW,500w SMPS,19" Viewsonic VX922 TFT,Logtech G5 Mouse,Altec Lancing 2:1 Speakers.

20-10-2007, 10:18 AM	#2 (permalink)
Gigacore Dreamweaver Join Date: Aug 2006 Location: Bangalore Posts: 3,885	Re: Problem In Excel... this is just because the word length or the bit is limited to 16 bits __________________ Today's noobs are tomorrow's geeks. Don't make fun of them.. encourage them. - Gigacore Follow me on twitter.com/gigacore

20-10-2007, 10:26 AM	#3 (permalink)
go4saket 9437077259 Join Date: Sep 2005 Location: Sambalpur, Orissa Posts: 1,252	Re: Problem In Excel... So does this mean that I cannot use a large number in Excel sheets. BTW, which is the largest number supported by 16 Bits... __________________ Win 7 Ultimate Abit IP35-E Mobo,C2Q 6600,4GB DDR2 RAM,XFX 8600GT 256MB DDR3 Gfx ,Seagate 1TB HDD,Sony DVD RW,500w SMPS,19" Viewsonic VX922 TFT,Logtech G5 Mouse,Altec Lancing 2:1 Speakers.

20-10-2007, 10:40 AM	#4 (permalink)
Gigacore Dreamweaver Join Date: Aug 2006 Location: Bangalore Posts: 3,885	Re: Problem In Excel... i really dont know. . . but try those numbers in Calculator too you will get the same . . . . you can get more info about 16 bits in wiki __________________ Today's noobs are tomorrow's geeks. Don't make fun of them.. encourage them. - Gigacore Follow me on twitter.com/gigacore

20-10-2007, 12:02 PM	#5 (permalink)
iinfi mekalodu Join Date: Oct 2004 Location: Navi Mumbai Posts: 1,495	Re: Problem In Excel... well try this ... right click on the cell (or range of cells) where u want this number to be displayed.. goto format cells >> number tab >> number option in the list box >> select "0" in decimal places. click on OK .. is this wat u want ?? __________________ mekalodu

Popular Categories

Popular Articles

Content Categories

Sister Sites

Follow Us

Facebook Channels

Digit Magazine

	Advertisements. Register and be a member of the community to get rid of them.
Advertisement

22-10-2007, 03:04 PM	#6 (permalink)
Ramakrishnan The Researcher Join Date: Mar 2006 Location: Mumbai Posts: 1,122	Re: Problem In Excel... Just format the cell in number format. If you get ###### like this, increase the width. That is all.

23-10-2007, 12:01 AM	#7 (permalink)
ayush_chh In The Zone Join Date: Nov 2005 Location: Bangalore Posts: 486	Re: Problem In Excel... guys i too have problem in excel..... what i want is, to enter a date in one cell and get the date after 30 days in some other cell automatically....how can i do this??? __________________ eXPerience is what a MAN learn's fROM.....

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
function problem in excel	march27	Software Q&A	1	20-09-2006 04:44 PM
Excel(ent) problem!	nil_3	Software Q&A	2	23-12-2005 08:55 PM
MS Excel worksheet columns not SORTING-PROBLEM MERGED CELLS	TVB RAJU	Software Q&A	1	29-07-2005 12:50 PM
Problem With Excel	ravimevcha	Software Q&A	3	03-04-2005 04:11 PM