| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number formatting | Excel Discussion (Misc queries) | |||
| How do I find highest number in a row and change color? | Excel Worksheet Functions | |||
| Random Number Questions | Excel Worksheet Functions | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| How do I find the first value in a column less than a number? | Excel Worksheet Functions | |||
Linear Mode
