Stopping conversion to an elipse character

G

Guest

How can I make Excel STOP converting 3 consecutive periods (input a three
separate characters) into an ellipse (single character)? The external data I
am importing uses each period as a place holder in a 18 alpha-numeric
character sequence, if there is no alpha or numeric for that position, it
uses a period - which when there are three consecutive period, Excel converts
it into the ellipse (one character).
 
G

Guest

You can delete that from the 'auto-correct' list. From the menu bar, select
Tools > Options, click the Spelling tab, then Auto Correct Options. Scroll
down til you see the offending entry, highlight it and click Delete.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ascii conversion 4
how to replace an unrecognised character 2
Annoying conversion of 2nd character from upper to lower case 2
remedy: import problems with alpha and numeric data in column 3
Making a function available in all sheets 1
Problems importing from DBF to Outlook 1
How to prevent auto-conversion to date in clipboard paste special? 3
importing more than 65536 rows from .csv file 1

Top