Yonian

Posts: n/a

Enter "1", cell show ".01". Why?

Any number typed into a cell is divided by 100.
If proceded by "=" the number is correct.
What caused this and how can I fix it?

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
Hit enter in cell & move text down in cell, not go to cell below.	raoul_duke	Excel Worksheet Functions	4	April 2nd 23 08:37 PM
Some formula results will not show up in the cell	Space Elf	Excel Worksheet Functions	3	August 1st 05 01:26 AM
Possible Lookup Table	Karen	Excel Worksheet Functions	5	June 8th 05 09:43 PM
show macro security setting in a cell	Mark	Excel Worksheet Functions	3	March 21st 05 07:53 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

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

About Us

"It's about Microsoft Excel"