Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
squarelock
 
Posts: n/a
Default 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 . . .
  #2   Report Post  
Rich
 
Posts: n/a
Default


-----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?
  #3   Report Post  
Alan
 
Posts: n/a
Default

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


  #4   Report Post  
Alan
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Turn off automatic date formatting? Nick Turner Excel Discussion (Misc queries) 3 July 13th 06 08:13 AM
Automatic backup copy craigq Charts and Charting in Excel 2 April 11th 05 04:57 PM
remove spaces in text in excel GnarlyCar Excel Discussion (Misc queries) 3 February 1st 05 05:02 PM
Is there an automatic way to change numbers such as 12312001 t curtev Excel Discussion (Misc queries) 1 December 29th 04 10:32 PM
Sumproduct ... Empty Cells vs Spaces? Ken Excel Discussion (Misc queries) 9 December 17th 04 08:03 PM


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"