View Single Post
  #5   Report Post  
Joanna
 
Posts: n/a
Default



"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.