G Guest Jun 26, 2006 #1 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
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
M MartinW Jun 26, 2006 #2 Hi JR, ##### means that your cell is not wide enough to display the data. Click and drag on the column border to make it show correctly. HTH Martin
Hi JR, ##### means that your cell is not wide enough to display the data. Click and drag on the column border to make it show correctly. HTH Martin
B Bernard Liengme Jun 26, 2006 #3 Column width is too narrow OR trying to work with negative dates These are the common causes of ########### best wishes
Column width is too narrow OR trying to work with negative dates These are the common causes of ########### best wishes
G Gord Dibben Jun 26, 2006 #4 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 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 Click to expand... Gord Dibben MS Excel MVP
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 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 Click to expand... Gord Dibben MS Excel MVP
