Re: Space between decimal numbers
- From: "Fred Smith" <fredsmith99@xxxxxxxxx>
- Date: Wed, 25 May 2005 22:16:27 -0600
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" <Timmy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:020924D0-A079-4D01-88C2-28AFFEE39F3E@xxxxxxxxxxxxxxxx
> 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" wrote:
>
>> 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" <Timmy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:EC49EE2B-CC3A-449E-9C58-CB654DAC0B47@xxxxxxxxxxxxxxxx
>> > Did this not help me.
>> >
>> > "Peo Sjoblom" wrote:
>> >
>> > > Do format>cells>number and select 2 decimal number
>> > >
>> > >
>> > > Regards,
>> > >
>> > > Peo Sjoblom
>> > >
>> > > "Timmy" wrote:
>> > >
>> > > > 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.
>> > > >
>> > > >
>>
>>
>>
.
- References:
- Space between decimal numbers
- From: Timmy
- RE: Space between decimal numbers
- From: Peo Sjoblom
- RE: Space between decimal numbers
- From: Timmy
- Re: Space between decimal numbers
- From: David McRitchie
- Re: Space between decimal numbers
- From: Timmy
- Space between decimal numbers
- Prev by Date: Re: trying to write a formula ivolving data validation
- Next by Date: Re: Help with Aging Report
- Previous by thread: Re: Space between decimal numbers
- Next by thread: Re: Space between decimal numbers
- Index(es):
Relevant Pages
|
