Thread: Format cells with 0 as the tenth digit
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Format cells with 0 as the tenth digit
Shane

I found that =0 won't work whereas ="0" will.

I guess because we are using a text function?


Gord


On Sat, 7 Feb 2009 11:46:00 -0800, Shane Devenshire
wrote:

4. In the second box enter the formula:
=-MID(C10,10,1)=0
5. Click the Format button

Reply With QuoteReply With Quote