View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] grettaw@drwaz.com is offline
external usenet poster
 
Posts: 1
Default Formula to identify decimal versus whole numbers

Alternatively (and this may be a new feature), if you select "Automatic" under formatting it will achieve the same result.

Ask me how dumb I feel that I just found that out after trying all these formulas.