View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default how can I sum up the values with more than 15 significant digits?

I would use LEFT and RIGHT to split the text strings with the long numbers
in them (with some extra complication to split in appropriate places if the
inputs aren't integers), then add the separate parts, then concatenate the
results.
--
David Biddulph

"mohammad" wrote in message
...
how can I sum up the values with more than 15 significant digits?