ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I type in a cell,it is giving me the ##### instead of $10.99 why (https://www.excelbanter.com/excel-worksheet-functions/109123-i-type-cell-giving-me-instead-%2410-99-why.html)

mizfroggie

I type in a cell,it is giving me the ##### instead of $10.99 why
 
When I type in $10.99 in a cell I am getting ##### instead of the $10.99. I
can't seem to find a way to change that. What do I have to do to get the
$10.99 into that cell?

S Davis

I type in a cell,it is giving me the ##### instead of $10.99 why
 
....

Im guessing you may have to double clikc the cell boundary at the top
of the sheet. If its in cell A for instance, double click the line
between 'A' and 'B'

Otherwise, right click the cell, go to Number, and select Currency.
mizfroggie wrote:
When I type in $10.99 in a cell I am getting ##### instead of the $10.99. I
can't seem to find a way to change that. What do I have to do to get the
$10.99 into that cell?




All times are GMT +1. The time now is 04:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com