Excel spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-3074218%22%20slang%3D%22en-US%22%3EExcel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3074218%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20clicked%20on%20accounting%20number%20format%2C%20the%20dollar%20amount%20that%20had%20been%20in%20the%20column%20of%20a%20spreadsheet%20I%20was%20working%20on%20disappeared.%20In%20their%20place%20is%20now%20%23%23%23.%20How%20do%20I%20correct%20it%3F%20I%20have%20tried%20reentering%20the%20dollar%20amount%20but%20it%20goes%20right%20back%20to%20%23%23%23%3C%2FP%3E%3CTABLE%20width%3D%22136%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2274%22%3ECost%3C%2FTD%3E%3CTD%20width%3D%2262%22%3EValue%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2046.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2046.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2046.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2046.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2053.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2053.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2053.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2053.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2047.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2047.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2047.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2047.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2047.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%2047.50%3C%2FTD%3E%3CTD%3E%23%23%23%23%23%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3074218%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

When I clicked on accounting number format, the dollar amount that had been in the column of a spreadsheet I was working on disappeared. In their place is now ###. How do I correct it? I have tried reentering the dollar amount but it goes right back to ###

CostValue
 $  46.50#####
 $  46.50#####
 $  46.50#####
 $  46.50#####
 $  53.50#####
 $  53.50#####
 $  53.50#####
 $  53.50#####
 $  47.50#####
 $  47.50#####
 $  47.50#####
 $  47.50#####
 $  47.50#####
 $  47.50#####
3 Replies
Try increasing the column width.

@Riny_van_Eekelen 

I tried that and it didn't help. 

Hello @RuthieW 

Select the cells then Ctrl +1 --> from the category click on Accounting

Make sure that the cell format is the same as the snapshot bellow.

 

 

Cells format.png