| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Text Numbers
Some of our users are getting data from clients and pasting the data into
the spreadsheet. Sometimes the years are text. Even though the cell is formatted as a number, being text it has a value of 0 to any cell that references it. If I use a macro to test its value it gives me a number. If I can find a way to detect this situation I can issue a Range("YearColumn").Value = Range("YearColumn").Value when deactivating the sheet. Or maybe just always do this when deactivating? Don <donwiss at panix.com. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there way of detecting whether a cell is Bold text? | Excel Discussion (Misc queries) | |||
| Detecting text and returning a value | Excel Discussion (Misc queries) | |||
| Detecting Numbers in a cell | Excel Worksheet Functions | |||
| Detecting Case of Text in a Cell | Excel Discussion (Misc queries) | |||
| Detecting Blanks and Non Text Characters. | Excel Worksheet Functions | |||
Threaded Mode
