Space between decimal numbers

T

Timmy

Hi:
Whenever I am typing any number in excel such as 14.00. Its putting double
spaces between 14.00 (e.g., 14. 00).

How can I correct this.
 
D

David McRitchie

Hi Timmy,
Guess that means "Did that. Didn't help me."
because as a question it doesn't mean much to me.
(if English is not your language, what language are you coming from?)
In fact do you use a comma for thousands separator and a period for decimal fraction.

Try hitting F2 then Enter, after the formatting.
Formatting does not actually change until reentered between text and number.

Will assume that you haven't change justification to left, right, or center
and that is left justified as text, the better test is to check with ISTEXT.

If you still have the original what do you see for Format, cells, custom
and what do you have for =ISTEXT(A1) if A1 is the cell.
 
T

Timmy

It doe not matter what language I am speaking. Bottom line is that when I am
typing the numbers, place a period, and hit next number, it automatically
puts two spaces.

I have checked the options, formatting, etc It's not helping me. Its pain
that whenever I have a number after typing I delete those two spaces and
after that it's fine.

David McRitchie said:
Hi Timmy,
Guess that means "Did that. Didn't help me."
because as a question it doesn't mean much to me.
(if English is not your language, what language are you coming from?)
In fact do you use a comma for thousands separator and a period for decimal fraction.

Try hitting F2 then Enter, after the formatting.
Formatting does not actually change until reentered between text and number.

Will assume that you haven't change justification to left, right, or center
and that is left justified as text, the better test is to check with ISTEXT.

If you still have the original what do you see for Format, cells, custom
and what do you have for =ISTEXT(A1) if A1 is the cell.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Timmy said:
Did this not help me.
Click to expand...
Click to expand...
 
F

Fred Smith

Check into Tools>Autocorrect. See if there's an entry which changes a period
to a period followed by two spaces. This could cause your problem.

While you're correct that it doesn't matter what language you speak, it does
matter whether you communicate effectively. Sometimes when we know your
native tongue, it helps us understand your post better. What David is
telling you is that you're not communicating clearly enough to allow
effective analysis of your problem. This group provides the quickest,
cheapest and most effective advice of any service on the net. To get this
free advice, all you have to do is be pleasant and state your problem
clearly. You may not think that's fair, but that's the way this board works.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


Timmy said:
It doe not matter what language I am speaking. Bottom line is that when I
am
typing the numbers, place a period, and hit next number, it automatically
puts two spaces.

I have checked the options, formatting, etc It's not helping me. Its pain
that whenever I have a number after typing I delete those two spaces and
after that it's fine.

David McRitchie said:
Hi Timmy,
Guess that means "Did that. Didn't help me."
because as a question it doesn't mean much to me.
(if English is not your language, what language are you coming from?)
In fact do you use a comma for thousands separator and a period for
decimal fraction.

Try hitting F2 then Enter, after the formatting.
Formatting does not actually change until reentered between text and
number.

Will assume that you haven't change justification to left, right, or
center
and that is left justified as text, the better test is to check with
ISTEXT.

If you still have the original what do you see for Format, cells,
custom
and what do you have for =ISTEXT(A1) if A1 is the cell.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Timmy said:
Did this not help me.

:

Do format>cells>number and select 2 decimal number


Regards,

Peo Sjoblom

:

Hi:
Whenever I am typing any number in excel such as 14.00. Its putting
double
spaces between 14.00 (e.g., 14. 00).

How can I correct this.
Click to expand...
Click to expand...
Click to expand...
 
H

Harald Staff

Timmy said:
It doe not matter what language I am speaking. Bottom line is that when I am
typing the numbers, place a period, and hit next number, it automatically
puts two spaces.
Click to expand...

We can't help you as long as you refuse to cooperate.

Best wishes Harald
 
Top