[NFBCS] Converting Formulas to Numbers in Excel

[Steve Shelton]

You will need to select all the cells with phone numbers to format the
number. Use the EXCEL Number Format option (control + 1) to format the
selected cells.

If you want EXCEL to format the phone numbers, tab to Category and arrow
down to Special. Then tab to the option drop down and arrow down to "Phone
Number". This will format in (999) 999-9999 format. If you just want the
phone number without formatting, I would suggest you select the "Text"
Category.


Hope this helps.

Steve
 Categorythe   

-----Original Message-----
From: NFBCS <nfbcs-bounces at nfbnet.org> On Behalf Of Leslie Fairall via NFBCS
Sent: Thursday, November 14, 2024 6:14 PM
To: Christopher Chaltain via NFBCS <nfbcs at nfbnet.org>
Cc: Leslie Fairall <fairall at shellworld.net>
Subject: Re: [NFBCS] Converting Formulas to Numbers in Excel

Thanks for all of the feedback. For some strange reason I'm getting a
decimal beside the last digits in the number. for example:
77744455.00
I just want numbers. How can I fix this?


-- 
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/stevesheltonokc%40gmail.c
om