Weird data entry problem

excelstarter

New Member
Joined
Nov 21, 2005
Messages
2
I encountered a weird problem these days when I use excel. Everytime I entered a number, like 52, after I pressed enter, the number became 0.0052. I examined the tools, format, data,.... Just don't know what is going wrong! :cry:

anybody help me? thanks!
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,062
Office Version
  1. 365
Platform
  1. Windows
Have you checked the Fixed Decimal option on the Edit tab when you goto Tools>Options...?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,909
Messages
5,574,979
Members
412,630
Latest member
Eireangel
Top