ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do I get rid of the automatic 2 spaces after every period (https://www.excelbanter.com/new-users-excel/16761-how-do-i-get-rid-automatic-2-spaces-after-every-period.html)

squarelock

how do I get rid of the automatic 2 spaces after every period
 
when i am in Excell and i put in 1.29 it always comes out as 1. 29

it does this is Word as well when ever i use a period anywhee it always puts
2 spaces in. if i go ... i get . . .

Rich


-----Original Message-----
when i am in Excell and i put in 1.29 it always comes

out as 1. 29

it does this is Word as well when ever i use a period

anywhee it always puts
2 spaces in. if i go ... i get . . .
.


Sounds like it could be a keyboard problem. Does it do
this in Notepad or any other application where you can
input characters?

Alan

"squarelock" wrote in message
...

when i am in Excell and i put in 1.29 it always comes out as 1. 29

it does this is Word as well when ever i use a period anywhee it
always puts 2 spaces in. if i go ... i get . . .


Sounds a bit like you have an entry in AUTOCORRECT along the lines of:

Replace "Dot" with "Dot Space Space"

Probably some typist who always figured they would need two spaces
after a full-stop in Word!

HTH,

Alan.



Alan

"Alan" wrote in message
...

Sounds a bit like you have an entry in AUTOCORRECT along the lines

of:

Replace "Dot" with "Dot Space Space"

Probably some typist who always figured they would need two spaces
after a full-stop in Word!

HTH,

Alan.


Just in case you aren't familar with AUTOCORRECT, from excel:

Tools - AutoCorrect

Look for a single period (dot) in the left hand list being replaced
with {dot}{space}{space} in the right hand list.

Select the entry, and delete.

Probably the same in Word.

HTH,

Alan.




All times are GMT +1. The time now is 05:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com