Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

like
Posting as :
works at
You are currently posting as works at

I’d assume in a financial statement each line will be the same type of formatting. To get negatives in parenthesis you need to do a special format type in excel. When you open that menu you should see a formatting option that will give you this no problem. Easy google too

like

Exactly, you'll just need to create a custom Excel format but it should be easy enough to figure out.

because this is a financial statement and i dont want concatenation to cause formatting issues in the future. im sure theres a more simple formatting trick that im just not aware of

like

There might be a better way to do this, but why not use the an if statement with a concatenate function?

Related Posts

Has anyone found a mask that you really like? Can you share where you got it from please?

like

I recently bought my 1st home in TX. I want to get into real estate and eventually own/rent out multiple homes. Are there any good recommendations/tips on books/articles/websites that others have used to get started?

I've read about HELOC and cash out refinance to get a 2nd home but articles are so scattered that it gets confusing which is better in terms of tax benefits and immediate costs, etc. Anything others have found helpful that summarized how to get started would be great!

like

Recs for gaming chairs? I would use it for work too (long hours working). Thanks!

like

Hi all, I’m looking to learn about how one can transition from PwC AC to PwC India.
I joined PwC AC Bangalore as a fresher and have been working here for 13 months.
I was randomly assigned to SAP, but I’ve realised I really want to move away from this and move towards what I originally planned on pursuing i.e. data analysis, I was already well versed in ML and DL with python.
If anyone has made a similar transition, it would be great if you could help me understand how do I go about this.

like

Hey everyone - I'm super new to Pittsburgh and have no idea where to start to get out there and start meeting people and doing fun things. I'm open to recommendations if you have any at all! Pretty lonely here lol

like

I’m looking for a Mobile App developer for our client in Pittsburgh. Any leads? Must have Android or IOS and Xamarin or C sharp or Java. Must be local within 100 miles. Fully remote ore 6 months contract with possible extension and bringing you in fulltime. Comment below or refer your friends/family. Thanks!

like

My grandma got admitted to the hospital 2 days ago and just got discharged. Just came to know today that my dad was also hospitalized but is totally fine now. They’re both ok but why does it hurt so

The learning and design content I write belongs to the company where I work. Am I able to add and/or share my work in my portfolio? Is it acceptable to create some generic content to demonstrate my skill set?

like

I've had three interviews so far: 1) with the recruiter, 2) with the hiring manager, 3) with the lead of an adjacent division. I was contacted by the hiring manager (just 5 days after interview 3) asking if I was still interested and if I'm available for another meeting. He mentioned it would only take 30 minutes. Any thoughts on what to expect?

like

I have a interview with Qualcomm for Embedded firmware development. Can someone suggest the interview rounds and expected areas for the interview. I am purely into automotive domain and the opportunity is totally new.

Also please leave a heart so that I can dm others for referrals

like

Got a Dubai Strategy& Senior Associate interview next week - anyone has tips/recommendations or things I should look out for? Maybe things that are different from the US.

like

How's everyone's schedule these days? EY getting busy already.

like

Looking for a single room in a shared occupancy in and around Hinjewadi from May. Any leads is highly appreciated. Thanks in advance(daily mail likhne ka aadat nahi gaya).

Hello everyone,
I am looking for a roommate(female) in Gulmohar orchid apartment kharadi, Pune. Fully furnished
Rent would be 7.5k per month. If anyone is interested pls contact me.

Single room available in a 2 BHK Fully Furnished Apartment in Kalyani Nagar, Pune from January end 2023.
- Location: Sai Nagari Society
- Room has double bed
- Air conditioner (AC)
- Attached Washroom with Geyser
- Room has almirah and curtains
- Double door Refrigerator
- Fully Automatic Washing machine
- Microwave Oven

Rent – 15k for single room
Security Deposit – 3 months rent (refundable)

DM me for any other details.

Post Photo
like

Is Infosys has some policy of 70% in 12th and graduation for experiance candidate also?

like

Fresh grad, just started work in the US (~1 month in) but want to move back to Dubai due to personal reasons. Will hitting the 6m mark (1y won’t be possible - immigration) be helpful? (Cont)

like

I am interviewing to be an instructional coach. Any tips?

like

My mind every time I meet new clients

Post Photo
likefunny

Why do holidays when you can extend your impact

Post Photo
like

Additional Posts in Excel Genius

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Any book recommendations on excel modeling for real world business applications?

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

How do I compare two sheets to make sure they are identical?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal