Skip to main content

Post content has been hidden

To unblock this content, please click here

Beginner September 2005

Excel Q

Gingey Wife, 12 September, 2008 at 11:33 Posted on Off Topic Posts 0 5

Saved

Reply

Report
Hide content

What sympbols do you put round text so you can put it in a cell. I want to use symbols that are normalls used in calculations.

Thanks

Report
Hide content

5 replies

Latest activity by FigJam, 12 September, 2008 at 12:16

Beginner
MrsTracey · 12 September, 2008 at 11:41
Report

Hide content
If you put a ' in front of whatever you want to type, the whole box is treated as text and you should be able to put those symbols in there.
- Reply
Beginner September 2005
Gingey Wife · 12 September, 2008 at 11:42
Report

Hide content
Thanks. I thought it was " or ' but I was putting one before and after. Doh!
- Reply
Beginner
MrsTracey · 12 September, 2008 at 11:54
Report

Hide content
Doh! Yep, it's just one at the beginning!
- Reply
Beginner
FigJam · 12 September, 2008 at 12:01
Report

Hide content
An alternative, if you want to do this for more than one cell, is to select the cells you want treated as text then right click. Select "Format Cells" and under the tab titled "Number", select category: text .

Apologies if you know this already and were looking for a different/shortcut way! ?
- Reply
Beginner September 2005
Gingey Wife · 12 September, 2008 at 12:05
Report

Hide content
View quoted message

That's alright. Yeah I was looking for the lazy way. :o)
- Reply

Beginner
FigJam · 12 September, 2008 at 12:16
Report

Hide content
I realised that after typing my reply, but thought I may as well hit "post" anyway!
- Reply

Win £3,000 for your wedding

Join Hitched Rewards, where you can win £3,000 simply by planning your wedding with us. Start collecting entries, it's easy and free!