find number

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
 
N

Naz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Cell data entering slow! 0
Word macro that can call cells out of Excel for a find and replace 0
Keeping to ms office 97 pro 0
Word- Find and Replace 1
Possible to Combine reports to's to a single box? 0
How to count the numbers in a Word document? 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0

Top