ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   the "#" signs are driving me crazy :-( (https://www.excelbanter.com/new-users-excel/158903-signs-driving-me-crazy.html)

Gordan

the "#" signs are driving me crazy :-(
 
hi,
simple question: i have a couple of fields and all of them are accounting
type/category
90% of fields are displayed normal, but some of them just show "#####" and on
mouse over it shows the number that stored in the cell
i really dont understand why is this happening because all field have the sam
eproperties :-(


thank you
gordan



Gordan

the "#" signs are driving me crazy :-(
 
never mind i'm an idiot :-)
the cell was to narrow


gordan



Gordan

the "#" signs are driving me crazy :-(
 
never mind i'm an idiot :-)
the cell was to narrow


gordan




Mike H

the "#" signs are driving me crazy :-(
 
Try increasing the column width

Mike

"Gordan" wrote:

hi,
simple question: i have a couple of fields and all of them are accounting
type/category
90% of fields are displayed normal, but some of them just show "#####" and on
mouse over it shows the number that stored in the cell
i really dont understand why is this happening because all field have the sam
eproperties :-(


thank you
gordan





All times are GMT +1. The time now is 12:12 AM.

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