Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
Reply
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
Subtracting two 2-decimal place numbers gives result 13-decimal places? [email protected] Excel Worksheet Functions 5 March 12th 07 10:38 PM
identify numbers and text differently in formula widman Excel Discussion (Misc queries) 3 November 14th 06 04:28 PM
How can I sort mostly 3 decimal with some 4 decimal numbers PeterM Excel Discussion (Misc queries) 4 August 16th 06 02:15 AM
Formula without using numbers after decimal in the answer Mustang Excel Discussion (Misc queries) 5 September 16th 05 04:35 PM
Identify Numbers Mandeep Dhami Excel Worksheet Functions 5 July 17th 05 11:32 AM


All times are GMT +1. The time now is 10:26 AM.

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"