| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching for numbers, do I enter the , or leave it out?
Hi all,
I'm trying to search for a number in the thousands on a big spreadsheet... Do I include the , e.g. 5,000 or just enter 5000? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Searching for numbers, do I enter the , or leave it out?
Set option to look in values if you include the comma.
Set option to look in formulas if you do not include the comma. Regards, OssieMac " wrote: Hi all, I'm trying to search for a number in the thousands on a big spreadsheet... Do I include the , e.g. 5,000 or just enter 5000? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Searching for numbers, do I enter the , or leave it out?
Leave out the commas. They are a formatting option, not part of the value.
wrote in message ups.com... Hi all, I'm trying to search for a number in the thousands on a big spreadsheet... Do I include the , e.g. 5,000 or just enter 5000? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The numbers I enter are changed when I leave the cell | Excel Discussion (Misc queries) | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Run formula only if values are enter, otherwise leave blank | Excel Worksheet Functions | |||
| Searching numbers in Worksheet | Excel Worksheet Functions | |||
| Searching numbers in Worksheet? | Excel Worksheet Functions | |||
Linear Mode
