LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
jezzica85
 
Posts: n/a
Default Finding cells with numbers

Hi all,
Does anyone know if there's a way to structure an if statement like:

IF(cell A1 contains a number),show cell A1,leave default FALSE

I've tried wildcards and I can't figure it out. I want to be able to make
this work if any number 0-9 is the first character in the cell, so it would
catch things like:

1
1939
20/20
1024-bit

but not things like:
Route 90
T1000 (I'm a T2 fan, can you tell? :) )

Thanks a lot!
jezzica85
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I use "VLOOKUP" with cells containing both Text & Numbers? Brentp97 Excel Worksheet Functions 7 February 24th 06 09:24 PM
Pivot Table keep apart cells text that I've formatted as numbers Paulo Bevervanso Excel Worksheet Functions 2 September 21st 05 08:45 PM
Hightlighting Numbers & then all Cells to the right of these Numbers. Dave Excel Worksheet Functions 4 August 29th 05 10:30 PM
check if 2 cells are equal but only if they contain numbers not i. Peter Boardman Excel Worksheet Functions 4 April 17th 05 08:16 PM
Converting negative numbers in a range of cells to zero Dede Excel Discussion (Misc queries) 3 January 14th 05 06:23 PM


All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"