Windows XP Ignoring formulas


Joined
Apr 20, 2006
Messages
1
Reaction score
0
Hi everyone,

I'm new to excel and was wondering if someone could help answer a simple question. I'm putting together a sheet of text. A lot of the cells have a dash before them e.g. "- After you have registered and logged in to the Xerox Extranet you will Presented with a page like this one."

However, it keeps trying to turn it into a formula because of the dash. Is there a way of getting excel to ignore the formula functions entirely?

Any help would be greatly appreciated.

Thanks,

James
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,002
Reaction score
1,025
Try putting in a space before the dash, as that should stop it :)

e.g. " - After you have registered and logged in to the Xerox Extranet you will Presented with a page like this one."

instead of "- After you have registered and logged in to the Xerox Extranet you will Presented with a page like this one."
 
Ad

Advertisements

Rush

Cool Cruncher
Joined
Nov 3, 2005
Messages
4,124
Reaction score
6
select the text you need to change ,Go to format on the toolbar , click cells and under number select text .:thumb:
 

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

Top