Microsoft Excel Question

Jon_Are

Senior HTF Member
Joined
Jun 25, 2001
Messages
2,036
I'm keeping a spreadsheet in Microsoft Excel, a program with which I am not very familiar.

Something crazy is happening. Well into my sheet (the 23rd row), I am not able to enter a simple number. I want to enter '77', and all goes well until I tab to another cell or hit enter, at which point my '77' changes to what appears to be a date ('03/17/00').

This is in column B; column A has a list of dates (the date corresponding to the problem row is 03/21/03).

I suspect that this cell is instructed to perform some sort of calculation (?).

Can anyone help me enter my 77 ???

Thanks!

Jon
 

Rob Gillespie

Senior HTF Member
Joined
Aug 17, 1998
Messages
3,632
The odds are Jon, that your cell has some kind of date formatting. Right-click on the cell and select Format Cells and see what's in there. If it is a formatting issue, then your number is still there but Excel is trying to display it according to the formatting applied to the cell. Change the formatting and all should be ok.
 

Forum Sponsors

Forum statistics

Threads
345,206
Messages
4,734,244
Members
141,410
Latest member
JayGeezy