| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you enter @ symbol without becomig email address in a cell?
I am trying to enter information in a cell, i.e. 4@50. It keeps turning the
information into an email address. How can I stop this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you enter @ symbol without becomig email address in a cell?
Hi
One way is to hit Ctrl+Z immediately after it has changed it into an email address. This will undo the 'helpful' change for you! Andy. "offcmanager" wrote in message ... I am trying to enter information in a cell, i.e. 4@50. It keeps turning the information into an email address. How can I stop this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you enter @ symbol without becomig email address in a cell?
I think you need to change an autocorrect setting.
Try this: ToolsOptionsSpelling tab Click the [AutoCorrect Options...] button Select the "AutoFormat as you type" tab Uncheck: Internet and network paths with hyperlinks Click the [OK] buttons Does that help? *********** Regards, Ron XL2002, WinXP-Pro "offcmanager" wrote: I am trying to enter information in a cell, i.e. 4@50. It keeps turning the information into an email address. How can I stop this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you enter @ symbol without becomig email address in a cell?
Hi again!
You could just format the column as Text before you start. Andy. "Ron Coderre" wrote in message ... I think you need to change an autocorrect setting. Try this: ToolsOptionsSpelling tab Click the [AutoCorrect Options...] button Select the "AutoFormat as you type" tab Uncheck: Internet and network paths with hyperlinks Click the [OK] buttons Does that help? *********** Regards, Ron XL2002, WinXP-Pro "offcmanager" wrote: I am trying to enter information in a cell, i.e. 4@50. It keeps turning the information into an email address. How can I stop this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you enter @ symbol without becomig email address in a cell
Or enter an apostrophe prefix to make the entry a label.
Old Lotus relic... -- Kevin Backmann "Andy" wrote: Hi again! You could just format the column as Text before you start. Andy. "Ron Coderre" wrote in message ... I think you need to change an autocorrect setting. Try this: ToolsOptionsSpelling tab Click the [AutoCorrect Options...] button Select the "AutoFormat as you type" tab Uncheck: Internet and network paths with hyperlinks Click the [OK] buttons Does that help? *********** Regards, Ron XL2002, WinXP-Pro "offcmanager" wrote: I am trying to enter information in a cell, i.e. 4@50. It keeps turning the information into an email address. How can I stop this? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you enter @ symbol without becomig email address in a cell?
Another method is to use a single quote (apostrophe) in front:
'4@50 -- Gary''s Student "offcmanager" wrote: I am trying to enter information in a cell, i.e. 4@50. It keeps turning the information into an email address. How can I stop this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I enter more than one line in the same Excel Cell by using. | Excel Discussion (Misc queries) | |||
| Stop next cell being selected on Enter | Excel Discussion (Misc queries) | |||
| ?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
| Help me Please!! Need hyperlinks to show actual email address! | New Users to Excel | |||
| how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
Linear Mode
