how to enter numbers value for calculation?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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.
 
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
 
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.
 
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.
 
Back
Top