error displaying large numbers
 

I formatted a cell as currency and tried to input a number larger than
1000 and the cell displays #######. Anyone know why this is and how to
fix it?


--
donkermazoid
------------------------------------------------------------------------
donkermazoid's Profile: http://www.excelforum.com/member.php...o&userid=37207
View this thread: http://www.excelforum.com/showthread...hreadid=569216

error displaying large numbers
 

Make the column wider or the font smaller ... or both

Regards

Trevor


"donkermazoid"
wrote in message
news:donkermazoid.2c6wdi_1154987409.2629@excelforu m-nospam.com...

I formatted a cell as currency and tried to input a number larger than
1000 and the cell displays #######. Anyone know why this is and how to
fix it?


--
donkermazoid
------------------------------------------------------------------------
donkermazoid's Profile:
http://www.excelforum.com/member.php...o&userid=37207
View this thread: http://www.excelforum.com/showthread...hreadid=569216

error displaying large numbers
 

Hi,

Resize column width. Either drag cell to fit or select column then
format column autofit.

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569216