ExcelBanter - Trying to put in figures over 100K

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Trying to put in figures over 100K (https://www.excelbanter.com/excel-discussion-misc-queries/185523-trying-put-figures-over-100k.html)

Lynn

Trying to put in figures over 100K

I'm trying to put in figures over 100K and it comes up with ###### instead of
the figure? Even if I type in the right figure?

Mike H

Trying to put in figures over 100K

Hi,

Try widening the column

Mike

"Lynn" wrote:

I'm trying to put in figures over 100K and it comes up with ###### instead of
the figure? Even if I type in the right figure?

jlclyde

Trying to put in figures over 100K

On Apr 29, 1:21*pm, Lynn wrote:
I'm trying to put in figures over 100K and it comes up with ###### instead of
the figure? *Even if I type in the right figure?

Coudl formatt cell to ahve smaller numbers or what Mike had said and
increase the width of the column. You coudl also format to be
scientific.
Jay

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