View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default 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