Formatting help

  • Thread starter Thread starter Walt Schroeder
  • Start date Start date
W

Walt Schroeder

I have an existing spreadsheet that I want to enter a date
in a cell. I formatted the cell for dates. When I enter
e.g. 1/26, the result is 01/00/00 and at the top it shows
=1/26. It appears that no matter which cell I use when I
enter the date as stated it does a calculation rather than
give a date. How do I stop the cells from doing a
calculation and just give me the date?
 
You have to enter the date in a format that Excel will
recognize, or pre-format the entry cells as text.

HTH
Jason
Atlanta, GA
 
Hi Walt!

I think that with your problem all you need to do is use:

Tools > Options > Transition
Remove check from Transition Formula Entry
OK

In Lotus 1/26 is evaluated as 1/26
With a date format this is represented as 0-Jan-1900 00:55:23 and
shown in the formula bar as =1/26

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Walt

Tools>Options>Transition. Uncheck "transition formula entry".

That is a Lotus setting and produces the =1/26 in the formula bar.

Gord Dibben Excel MVP
 
Back
Top