| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find all cell with a decimal value
I am in a blank sheet in a worksheet.
Is there a way to return all the cells within the worksheet that have a value behind the decimal? For example: 1,245.00 would not be returned because it is 0 after the decimal but 1,245.01 would be returned. I am only looking for this to 2 decimal places. Thank you, Steven |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find records with values more then 2 decimal places. | Excel Discussion (Misc queries) | |||
| can not find align decimal points option | Excel Discussion (Misc queries) | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| Find do not work with decimal point | Excel Programming | |||
| Show a time from one calculated cell as a decimal in another cell. | Excel Worksheet Functions | |||
Threaded Mode
