find number

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi,
In a cell appears a #. How can I find this # & move it to a separate cell.
I have excel 97 & XP
Thanks, Dave
 
Not quite sure what you mean, but you can find any # on a sheet by using Edit
Find.
Click to expand...


If is a string of ###### you see then that means the column is not wide
enough to display the contents of the cell. Increase the width by selecting
the column, right click column width and increase it.
 
Back
Top