|
Posted to microsoft.public.excel.newusers
|
|
|
Cell Won't Accept Numerical Data
It worked, thank you.
"Bernard Liengme" wrote:
Select the cell; sue Edit | Clear | Clear All to get rid of formatting and
alignment
Now type the number or text
Why ALT+Enter? That is to break a text entry into two lines
Tell us what happens
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Chatelaine" wrote in message
...
I'm trying to edit one cell, and Excel 2003 refuses to accept any changes.
The problem with the cell is that it keeps mis-aligning. I've tried
clearing
it, and that works, but when I re-enter the data, it insists on entering
the
data the same way. I've tried editing in the fx function bar, but the
program still insists on entering the same data the same way, that is,
mis-aligned. I've tried turning off the enable auto complete for cell
values, and that didn't help. Then I tried following some MS
troubleshooting
steps: double-click the cell, delete the data (so far, so good), then alt
+
enter, and then enter again, to begin entering the data. Well now, I
can't
enter any data, period. The cell no longer accepts any data. The rest of
my
sheet looks great, except for my first numerical entry, which is screwing
everything up. The only other thing I can think of is to do the whole
sheet
over, that is, start with a new document. Can anyone help me out on this?
Thanks.
|