cannot enter correct numbers in cells

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

Guest

Every time I enter a number in a cell and click enter I get a date format or
a string of numbers. I format the cell and the same thing happens. What is
causing this?
 
Have you tried selecting the cell, then going to menu>edit>clear>all?
 
jb

A samll example of the type of numbers you are entering would be handy.

And a small example of what they turn into when you hit enter.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

have date show in cell when only entering numbers 3
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
can a cell be both input and output? 2
Date/Time 1
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Problem entering dashes in certain spots 4
Stop Excel Changing Format 3
how to enter numbers like 8:0 or 2:8 in a cell 6

Back
Top