Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Harry Hunter   on Jan 14 In MS Office Category.

  
Question Answered By: Jennifer Davis   on Jan 14

In A1 your "integer of up to ten digits (no digit can be a zero)", in
any other cell  that "single formula in a cell (albeit a very long
one)" array-entered:

=SUM(SMALL(VALUE(MID($A$1,ROW(INDIRECT("A1:A" &
LEN(A1))),1)),ROW(INDIRECT("A1:A" &
LEN(A1))))*10^(LEN(A1)-ROW(INDIRECT("A1:A" & LEN(A1)))))

making sure the cell is wide enough to show all the digits. Will work
up to 15 digits but for more than 11 digits it requires the cells  to
be formatted as Number with no decimal places.
There will be a shorter one I'm sure!

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Distance Function Or get search suggestion and latest updates.


Tagged: