Thread: Problem with concatination result. Last digit change to 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DavCan DavCan is offline
external usenet poster
  
Posts: 1
Default Problem with concatination result. Last digit change to 0
Here are the steps I am performing
I am concatinating 2 numeric fields.
Copy Paste Special Values - This then makes the result text
A warning box comes up and I click on it and specify to convert to number
When it converts the result, it formats it to Scientific notation
I then format it to Number with zero decimals
This then changes the last digit to 0.
910000026 1370735 is what I begin with 9100000261370730 is what I end up
with
Reply With QuoteReply With Quote