Custom format whole number to decimal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day,

I am currently using a custom format to automatically display a whole number
as a number with decimals: ###0\.00 however, I was wondering if it was
possible to have a custom format perform the same function, but with a comma
value as well e.g. (#,##0\.00) - this does not work.
 
Try:

[>100000]#\,##0\.00;##0\.00

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
As it says in some shops: "For display only"

--


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


Sandy Mann said:
Try:

[>100000]#\,##0\.00;##0\.00

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
Try this:

[>99999]#","##0"."00;##0"."00
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Good day,

I am currently using a custom format to automatically display a whole number
as a number with decimals: ###0\.00 however, I was wondering if it was
possible to have a custom format perform the same function, but with a comma
value as well e.g. (#,##0\.00) - this does not work.
 
In that case 123456 shows as: 123,456.00

I assume that the OP wants: 1,234.56

I can only assume it is for easy data entry and the Op is going to divide
the number by 100 when it is used. Although having to enter an extra double
zero for whole numbers would cause me more trouble than entering e decimal
point.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
You may be right in what you think the OP wants Sandy........I guess it's all
in how the reader perceives it......woulda probably been clearer if the OP
would have provided an example.........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top