#1   Report Post  
Posted to microsoft.public.excel.misc
ShakespearesEdge
 
Posts: n/a
Default ###??

Why do I keep getting these signs ##### in place of numbers (totals?) on my
spreadsheet??

Thanks very much!
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bondi
 
Posts: n/a
Default ###??

Hi,

One guess would be that your cells are too short to display the entire
contents.
You might be able to correct this by extending the lenght of the
columns by clicking in the split between the column headers and draging
to the right.

Another would be that you should format your cells to display Number.
Right click on a cell and select Format. Then chose number.

Regrads,
Bondi

  #3   Report Post  
Posted to microsoft.public.excel.misc
ShakespearesEdge
 
Posts: n/a
Default ###??

Thanks very much..I think that's it!

"Bondi" wrote:

Hi,

One guess would be that your cells are too short to display the entire
contents.
You might be able to correct this by extending the lenght of the
columns by clicking in the split between the column headers and draging
to the right.

Another would be that you should format your cells to display Number.
Right click on a cell and select Format. Then chose number.

Regrads,
Bondi


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"