ExcelBanter - A number value in Excel will on view as ####. How do I fix this?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - A number value in Excel will on view as ####. How do I fix this? (https://www.excelbanter.com/new-users-excel/82278-number-value-excel-will-view-how-do-i-fix.html)

BrianSteven215

A number value in Excel will on view as ####. How do I fix this?

Why is it every other cell will show the number value, but one cell will only
show ###### in the cell? How do I correct this? Thanks.

Carim

A number value in Excel will on view as ####. How do I fix this?

Is it just the column width to be increased ... ?

--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=531180

L Sholes

A number value in Excel will on view as ####. How do I fix this?

Yes. Either manually resize the column, or click: FormatColumnAutoFit
Selection

L Sholes

A number value in Excel will on view as ####. How do I fix this?

Yes. Either manually resize the column, or click: FormatColumnAutoFit
Selection

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