how to enter numbers value for calculation?

J

Joanna

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

Bob Phillips

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)
 
J

Joanna

Bob Phillips said:
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)
Click to expand...
Thank you, Bob.
But, column is formated as GENERAL.
Joanna.
 
D

Dave Peterson

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
 
J

Joanna

Dave Peterson said:
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
Click to expand...

Thank you, Dave!!!

But it is does not help.

Joanna. 08/25/2005.
 
J

Joanna

Dave Peterson said:
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()")
Click to expand...

Thank you, Dave again!!!

I found the problem:

" 'TOOLS'-
Formula auditing -
Formula auditing mode " --- WAS 'ON'.

Thank you again.

Joanna.
08/25/2005.
 
Top