Thread: Why doesn't "Replace" function find value I know exists?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Why doesn't "Replace" function find value I know exists?
Good point David.

May have nothing at all to do with hidden decimals.


Gord


On Thu, 28 Jan 2010 08:19:46 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

Excel doesn't store the number as 1000.00. It stores it as 1000.

Reply With QuoteReply With Quote