ExcelBanter - find number

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - find number (https://www.excelbanter.com/new-users-excel/28155-find-number.html)

Dave

find number

Hi,
In a cell appears a #. How can I find this # & move it to a separate cell.
I have excel 97 & XP
Thanks, Dave

Naz

Not quite sure what you mean, but you can find any # on a sheet by using Edit
Find.

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.
--

_______________________
Naz,
London

"Dave" wrote:

Hi,
In a cell appears a #. How can I find this # & move it to a separate cell.
I have excel 97 & XP
Thanks, Dave

All times are GMT +1. The time now is 07:20 PM.