how to enter numbers value for calculation?
 

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.

It sounds as if that column is formatted as text. Reformat it to General.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Joanna" wrote in message
...
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.

"Bob Phillips" wrote:

It sounds as if that column is formatted as text. Reformat it to General.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Joanna" wrote in message
...
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.



Thank you, Bob.
But, column is formated as GENERAL.
Joanna.

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

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

Are you typing that value in or pasting it (like from a web page)?

If you're pasting, maybe you have extra characters (additional spaces or HTML
non-breaking spaces).

David McRitchie has some code that will help clean this junk up:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

Joanna wrote:

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

--

Dave Peterson