Posted to microsoft.public.excel.misc

Irfan Khan[_2_] Irfan Khan[_2_] is offline

external usenet poster

Posts: 28

Excel automatically dividing value by 100...

Whenever i am enetering any number in excel it is automatically deviding it
by 100 like if I enter 2 then it will store as 0.002. Whenever I am having
any formula calculation then there is no prblem .... Can anybody help me ???

Thanks a lot

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dividing in excel easy questions	HELP PLEASE HELP	Excel Discussion (Misc queries)	3	November 9th 07 08:07 PM
Excel is dividing my entries...why??	JMc	Excel Discussion (Misc queries)	1	October 23rd 07 03:29 AM
Dividing range of numbers automatically	Slashman	Excel Worksheet Functions	3	October 12th 06 02:46 AM
My excel spread sheets are dividing all numbers input by 100.	Prospector	Excel Worksheet Functions	3	July 21st 06 10:47 AM
What is the formula for dividing a number by 4 in excel	Blessingspoint	Excel Worksheet Functions	1	January 13th 05 05:58 PM

All times are GMT +1. The time now is 02:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us