Posted to microsoft.public.excel.misc

Ashley Luo Ashley Luo is offline

external usenet poster

Posts: 1

Why does 100 turn into 1 when I enter it into a cell?

I typed the number 100 in a cell and it automatically turned into 1.
Similarily, when I typed the number 1, it automatically turned into 0.01.
Excel is dividing every number I type by 100. Does anyone know why that is
and how I can fix it?

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
insert date	Larry	Excel Worksheet Functions	28	July 15th 06 02:41 AM
Need help with an embedded IF statement	Lari	Excel Worksheet Functions	8	June 17th 06 04:59 PM
Enter 2 dates in same excel cell	m_a_turcotte	Excel Discussion (Misc queries)	4	May 16th 06 08:15 PM
Hitting Enter to Move Cursor to the Next Entry Cell	Cisnerax	Excel Worksheet Functions	3	February 25th 06 11:04 AM
Stop next cell being selected on Enter	Ken G.	Excel Discussion (Misc queries)	2	December 6th 05 07:21 AM

All times are GMT +1. The time now is 09:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us