Thread: why do i get ###### in cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default why do i get ###### in cells
One other potential cause for #############

Excel has a problem with cells that contain 255 but <1024 characters.

Fornat the cell to General and your ############## should go away.


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 07:10:02 -0700, j r williams <j r
wrote:

i get the pound sign in some cells not what i insert, in some it shows right
in the formula bar ,some it only shows the formula

Gord Dibben MS Excel MVP
Reply With QuoteReply With Quote