LIFamilies.com - Long Island, NY


RSS
Articles Business Directory Blog Real Estate Community Forum Shop My Family Contests

Log In Chat Index Search Rules Lingo Create Account

Quick navigation:   

Excel Question

Posted By Message

MsG
Should be working

Member since 5/05

2824 total posts

Name:
G

Excel Question

Does anyone know how to get the = sign to be treated like a symbol and NOT as a command to calculate?

I tried formatting as text but that didn't work.

Never mind, I got it - I inserted it as a symbol

Message edited 4/17/2006 3:24:05 PM.

Posted 4/17/06 3:21 PM
 
Long Island Weddings
Long Island's Largest Bridal Resource

Ang-Rich
Beyond Compare

Member since 5/05

17988 total posts

Name:

Re: Excel Question

Usually I just put in the = sign and hit enter and it's fine.

Maybe try putting a ' before the =

Posted 4/17/06 3:24 PM
 

ODonnell
.

Member since 9/05

5983 total posts

Name:

Re: Excel Question

If you go to Format - cells and pick text it should let you put in anything

Posted 4/17/06 3:26 PM
 

LadyMaravilla
Fall Is Here

Member since 5/05

12023 total posts

Name:
Sonia

Re: Excel Question

I typed the "=" sign and it worked.

Posted 4/17/06 3:29 PM
 

dpli
Daylight savings :)

Member since 5/05

13973 total posts

Name:
D

Re: Excel Question

Posted by Ang-Rich

Usually I just put in the = sign and hit enter and it's fine.

Maybe try putting a ' before the =



I know you got it already, but I thought I would add that you can put an apostrophe ' before any symbol or number and it will enter it exactly as you type it.

I have had trouble with Excel automatically formatting numbers as dates, and this is often easier than having to format individual cells.

Posted 4/17/06 4:32 PM
 

nrthshgrl
It goes fast. Pay attention.

Member since 7/05

57538 total posts

Name:

Re: Excel Question

Posted by dpli

Posted by Ang-Rich

Usually I just put in the = sign and hit enter and it's fine.

Maybe try putting a ' before the =



I know you got it already, but I thought I would add that you can put an apostrophe ' before any symbol or number and it will enter it exactly as you type it.

I have had trouble with Excel automatically formatting numbers as dates, and this is often easier than having to format individual cells.



Works for zip codes that start with '0' too Chat Icon

Posted 4/17/06 4:56 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
Dumb excel question JenniferEver 4/23/06 3 Families Helping Families ™
I have a question and Forgive me post( another question on bottom) luvsbob4603 6/16/06 14 Families Helping Families ™
Another question before I become a mom- Hospital question Shelly 4/10/06 11 Parenting
This isnt a TTC question - more so a BCP question Gdesq 5/25/05 9 TTC
where can i download microsoft excel for free?? w/no viruses? raken40 10/24/05 3 Families Helping Families ™
City Girls! Restaurant question! azoodie 9/19/06 12 Families Helping Families ™
 
Quick navigation:   
Currently 588693 users on the LIFamilies.com Chat
New Businesses
1 More Rep
Carleton Hall of East Islip
J&A Building Services
LaraMae Health Coaching
Sonic Wellness
Julbaby Photography LLC
Ideal Uniforms
Teresa Geraghty Photography
Camelot Dream Homes
Long Island Wedding Boutique
MB Febus- Rodan & Fields
Camp Harbor
Market America-Shop.com
ACM Basement Waterproofing
Travel Tom

      Follow LIWeddings on Facebook

      Follow LIFamilies on Twitter
Long Island Bridal Shows