How do I correct a Excel cell value from a date to a number?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For some reason that I cannot explain when I type the straight numeric value
617 in the A Cell of my spreadsheet, Excel converts it to 9/7/1901 or 9-Sep.

In Tools Menu, Options, Edit I have cleared the check box for Automatic
completion.

I do not no why Excel is inserting a date value in the cell, and I have not
been able to edit and correct that A cell value back to 617 without Excel
changing number back to the date 9/7/1901 or 9-Sep format.

Thank you for any help you can give me to rectify this problem.

Tom
 
For some reason that I cannot explain when I type the straight numeric value
617 in the A Cell of my spreadsheet, Excel converts it to 9/7/1901 or 9-Sep.

In Tools Menu, Options, Edit I have cleared the check box for Automatic
completion.

I do not no why Excel is inserting a date value in the cell, and I have not
been able to edit and correct that A cell value back to 617 without Excel
changing number back to the date 9/7/1901 or 9-Sep format.

Thank you for any help you can give me to rectify this problem.

Tom
Click to expand...

You checked AutoComplete, but you didn't check the cell format:
Format + Cells + Number
Set it to number or general or currency but not Date.

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct Excel newsgroup. I would suggest you
include your Windows and Office version number in the message.
 
Back
Top