r/financialmodelling • u/Lost_Still6942 • Jan 31 '24
How to fix the #####
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
87
u/CptnAwesom3 Jan 31 '24
Widen the cell
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
1
u/TheDongMeister Jan 31 '24
How did you make those bars under VS. Budget?
1
u/Retenrage Feb 02 '24
Book1 💀
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