HI,

If I have a series of numbers in Cell A1: A10 like 156789 etc

I want to be able to do 2 kinds of operations:-

a) How to set the format, so that number gets displayed as 156.789 or
let' say 157 . I have seen folks using custom formats but not sure how
to set it up in this case.

b) How to set the format in such a way that we may also be see "157
Thousand" for above case. Is it possible using custom formats. (I will
like to do the same thing for 1234567 as "1.2 Million" and so on)

Please guide me.

Regards,
HP
India