Inserting & within Excel spreadsheet to show as &

M

Melissa

I am trying to type the ampersand within an Excel spreadsheet and cannot
remember HOW to make it look like: &
When I do it, it thinks I am trying to do a command or a formula or
something. All I want to do is put this in my spreadsheet because it's the
name of a company: &

Thanks a bunch for the help!
 
S

Susan

if that's the sole character, put a quote mark in front of it.
if it's in the middle of a bunch of characters, it shouldn't trigger
anything.
if it does, try a quote mark at the beginning of the text.
:)
susan
 

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

Opening excel 2010 spreadsheet from Access 4
Alt codes 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to copy page breaks within an Excel spreadsheet? 1
Lock location of sheet within a spreadsheet 4
excel spreadsheet not visible 1
Entering 'GTi' but I get 'Gti' ! 2
edited spreadsheet saves as template 9

Top