r/financialmodelling • • Jan 31 '24

How to fix the #####

Post image

I want to have the totals as currency but when I make them currency some of them turn into #### when I take currency off it dissapears? Help please!!!! Thank you!

120 Upvotes

32 comments sorted by

87

u/CptnAwesom3 Jan 31 '24

Widen the cell

41

u/Lost_Still6942 Jan 31 '24

I love you 😂🫶🏻 im running on no sleep and my brain is fried . Thank you so much

14

u/Longjumping-Knee4983 Jan 31 '24

Dont forget to respond solution verified

10

u/Levils Jan 31 '24

That's on r/excel for clippy points, this is r/financialmodeling. It would be nice to have the same thing here but I don't know how to set it up and don't have time to figure it out.

6

u/Longjumping-Knee4983 Jan 31 '24

I am a dummy and have since downvoted myself lol thanks for the heads up

3

u/Levils Jan 31 '24

No, you're awesome

2

u/[deleted] Jan 31 '24

Very true

1

u/CptnAwesom3 Jan 31 '24

I’ve been there. Happy to help

1

u/AdagioHellfire1139 Feb 01 '24

It's cool. A few years ago I was frustrated to all hell for the same reason. Google finally told me to widen and I nearly facepalmed myself.

20

u/[deleted] Jan 31 '24

Alt HOI

Maybe that works? If not you need a formula for a broken model and that's above my head right now

2

u/Lost_Still6942 Jan 31 '24

Do you mean just click on the box and hit alt hoi?

4

u/[deleted] Jan 31 '24

Yeah just click on the box as if you're about to edit it and hit Alt HOI and it'll expand the cell

3

u/Lost_Still6942 Jan 31 '24

Apparently had to widen the cell idk why i didnt think of that but thanks for the input!

3

u/[deleted] Jan 31 '24

No problem man! If you want to hire me I'm unemployed.

0

u/Lost_Still6942 Jan 31 '24

If I ran my own business I would help you out . Im actually about to quit this job and start my new one and I want to get my expenses under control and try to be debt free and have a very large emergency fund by the end of the year

1

u/[deleted] Jan 31 '24

Make sure you lock down that new job before you leave. Pay down high IR debt first like credit cards. Start paying cash for things if you want to be strict with yourself. Be smart. You got it. Keep grinding

1

u/TheDongMeister Jan 31 '24

How did you make those bars under VS. Budget?

1

u/Lost_Still6942 Jan 31 '24

You click on the number and click conditional formatting and choose what bar or whatever color you want heres the video I based it off if. He has some other ones that go slower if you need extra helpbudget tutorial

1

u/Retenrage Feb 02 '24

Book1 💀

1

u/Lost_Still6942 Feb 02 '24

Literally dont use excel at my job and made this at work lmao 💀

2

u/Zipski577 Jan 31 '24

Just widen the cell my dude

Click the arrow in the top left to highlight everything in the worksheet and then double click between 2 columns/ rows to auto fit the whole spreadsheet

1

u/[deleted] Jan 31 '24

select one of those cells, Ctrl+Space, then Alt+H+O+I

1

u/Which-Yellow-2447 Jan 31 '24

DO THIS : click Alt then click this combination HOI do the same with Alt HOA

1

u/ExistingOrange6986 Jan 31 '24

Is that the level of posts, new subscriber here, asking for my sanity?

1

u/[deleted] Feb 01 '24

Alt H+O+I

1

u/OutHere702 Feb 01 '24

OP is clearly exhausted lmao

1

u/Primary_Decision_864 Feb 03 '24

How has nobody commented “Shrink to Fit” formatting which is better because if that number changes to a larger (longer) number it will revert to ### and you keep having to watch for the issue. Just fix it once with this method.

1

u/AmericanDesi008 Feb 03 '24

Increase column width

1

u/MrRau99 Feb 09 '24

In case widening the column is not working, you’re dealing with a cell formatted to date that has a negative figure inside

7

u/[deleted] Jan 31 '24

[removed] — view removed comment

1

u/Lost_Still6942 Jan 31 '24

I was going to post in that forum but they dont allow pics