| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cannot enter correct numbers in cells
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cannot enter correct numbers in cells
Have you tried selecting the cell, then going to menueditclearall?
jb wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cannot enter correct numbers in cells
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 On Sat, 7 Oct 2006 14:12:01 -0700, jb wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto formats cells with numbers - Can it be disabled? | Setting up and Configuration of Excel | |||
| How do I enter formula for < or numbers. | Excel Worksheet Functions | |||
| How to alter data on HTML webpage into Excell cells as numbers? | New Users to Excel | |||
| how to enter telephone numbers in Excel sheet | Excel Discussion (Misc queries) | |||
| I enter numbers and they are stored as text | Excel Discussion (Misc queries) | |||
Linear Mode
