Auto-format/fill setting that forces any cell input to be a Formul

G

Guest

Does anyone know of an auto-format, auto-fill setting in Excel that would
force any input into a cell to become a formula? For example, we're trying
to enter dates into a worksheet, but everywhere we try to input a date, say,
5/21/07, the cell value is being forced into =5/21/7. I've searched
everywhere, but can't find out what ghost is causing this!

Note: No macros/VBA are attached to this sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fill cell reference 1
Using codes to input saved info into a cell? 1
auto fill certain data from sheet1 to sheet 2 2
Adding fill to cells only when value is "No" in another cell 1
Get Date from one cell to format another, then... 6
How to input pictures automatically based on cell input? 9
Using VBA To Enter A Sumproduct Formula Into A Cell 0
format cell to know number of another cell automatically 2

Top