Date or Calculation Problem???

jdowski · May 16th, 2002, 08:10 AM

Hi,
Someone brought to my attention a worksheet on which when she tried to enter dates such as: 5/22/02. However,it displayed as 0.001248751. I think Excel is trying to read the entry as a calculation trying to divide 5 into 22 into 2. I thought I read somewhere that there is a setting in Excel where you don't have to enter an = sign before every formula. I don't know where it is though or if that is the solution. Any ideas ????

Thanks,

Joe
Woodbury, CT.

Von Pookie · May 16th, 2002, 08:20 AM

Go to Tools / Options / Transition tab.

Under Sheet options, uncheck the box next to "Transition Formula Entry."

May 16th, 2002, 08:20 AM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Go to Tools / Options / Transition tab. Under Sheet options, uncheck the box next to "Transition Formula Entry." __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

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

May 16th, 2002, 08:10 AM	#1
jdowski Board Regular Join Date: Apr 2002 Location: Oxford, Connecticut USA. Posts: 235	Hi, Someone brought to my attention a worksheet on which when she tried to enter dates such as: 5/22/02. However,it displayed as 0.001248751. I think Excel is trying to read the entry as a calculation trying to divide 5 into 22 into 2. I thought I read somewhere that there is a setting in Excel where you don't have to enter an = sign before every formula. I don't know where it is though or if that is the solution. Any ideas ???? Thanks, Joe Woodbury, CT.