Thread: Excel 2000
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Excel 2000

=CELL("format",A1) will give the format code of cell A1
but is not much use for strikethrough
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ken" wrote in message
...
How do I use a if statement to determine if a number has been formatted
with
a strikethrough?

I could not locate a function that determines the formatting of a number.