"Dave Peterson" wrote:
If you formatted the column as text, did your data entry, then reformatted the
column as General, it's not enough.
Try this:
select an empty cell
edit|copy
select your range of cells to convert to numbers (the whole column???).
edit|paste special|check add
Joanna wrote:
EXCEL 2003.
I am unable to enter numeric value to the cell for calculation.
When I enter 1234 it is automatically aligns to the left of the cell, making
it a left-justified entry. It is a number that will not be used in
calculation.
How I can correct this problem and be able to enter to the cell
right-justified numbers whith numeric value?
08/24/2005.
--
Dave Peterson
Thank you, Dave!!!
But it is does not help.
Joanna. 08/25/2005.
|