ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   ### (https://www.excelbanter.com/excel-worksheet-functions/119497-a.html)

acomputer4u

###
 
### appears when putting a number into a field. How do I get rid of this
format?

Teethless mama

###
 
Expanse your column width

"acomputer4u" wrote:

### appears when putting a number into a field. How do I get rid of this
format?


watchtower

###
 
scroll you mouse in-between columns. when your curser turns to a line with
two arrows pointing away, double-click. the column will automatically adjust
to fit the largest date in the set.

"acomputer4u" wrote:

### appears when putting a number into a field. How do I get rid of this
format?


Dave Peterson

###
 
Or use a smaller font.

acomputer4u wrote:

### appears when putting a number into a field. How do I get rid of this
format?


--

Dave Peterson

zz

###
 
you could apply this format to your entire column

format-- |
|
cells--


tab " aligment "


option " shrink to fit"



"acomputer4u" wrote in message
...
### appears when putting a number into a field. How do I get rid of this
format?




acomputer4u

###
 
So on a number field when there is not enough room to put the data in it puts
up ##'s!, thanks so much!!!!!!!!!!

"acomputer4u" wrote:

### appears when putting a number into a field. How do I get rid of this
format?



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

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