[NFBCS] Converting Formulas to Numbers in Excel

[Christopher Chaltain]

I agree, but I wonder why these phone numbers are even showing up as formulas in the first place. It would be interesting if someone did an F2 and pasted the formula into a post to this list. I wonder if they're really showing up as links instead of formulas.


--
Christopher (AKA CJ) =>÷
Chaltain at Outlook, USA

-----Original Message-----
From: NFBCS <nfbcs-bounces at nfbnet.org> On Behalf Of Brad Snyder via NFBCS
Sent: Thursday, November 14, 2024 8:41 AM
To: nfbcs at nfbnet.org
Cc: Brad Snyder <wbsjr at swbell.net>
Subject: Re: [NFBCS] Converting Formulas to Numbers in Excel

Actually, the format for the cells that contain phone numbers should be changed to Text. This is because, even though these cells contain numbers, these numbers do not have value. They are phone numbers, and phone numbers though they are numbers are actually text. Therefore, the proper format for these cells that contain phone numbers is Text.
Hope this makes sense.

- Brad -

On Nov 14, 2024, at 07:01, Tracy Carcione via NFBCS <nfbcs at nfbnet.org> wrote:

It's been a while, but I think what you need to do is select the column where the numbers are, then go to the format menu and change it to numbers.

I'm thinking you can get to that menu with the applications key, aka right click.  On my Windows keyboard, it's the key just to the right of alt on the right side of the spacebar.
HTH.
Tracy


-----Original Message-----
From: NFBCS <nfbcs-bounces at nfbnet.org> On Behalf Of Leslie Fairall via NFBCS
Sent: Thursday, November 14, 2024 6:40 AM
To: NFB in Computer Science Mailing List <nfbcs at nfbnet.org>
Cc: Leslie Fairall <fairall at shellworld.net>
Subject: [NFBCS] Converting Formulas to Numbers in Excel

I have a list of several names and phone numbers in Excel. The numbers are appearing as formulas. Can someone provide instructions on converting these formals to numbers? I've done it before, but cannot remember. Any help would be appreciated.

--
Leslie Fairall
mailto:fairall at shellworld.net

_______________________________________________
NFBCS mailing list
NFBCS at nfbnet.org
http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
To unsubscribe, change your list options or get your account info for NFBCS:
http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/carcione%40access.net


_______________________________________________
NFBCS mailing list
NFBCS at nfbnet.org
http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
To unsubscribe, change your list options or get your account info for NFBCS:
http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/wbsjr%40swbell.net


_______________________________________________
NFBCS mailing list
NFBCS at nfbnet.org
http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
To unsubscribe, change your list options or get your account info for NFBCS:
http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/chaltain%40outlook.com