Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stopping conversion to an elipse character
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). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stopping conversion to an elipse character
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. "Q1" wrote: 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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Odd! Excel changes my letter character. Why? | Excel Discussion (Misc queries) | |||
Count occurrence of character within a cell | Excel Discussion (Misc queries) | |||
How to assign character (text) values to y-axis in a Excel chart? | Charts and Charting in Excel | |||
install Office Assistant character file? | Excel Discussion (Misc queries) | |||
Removing ' character from cells | Excel Discussion (Misc queries) |