Format Cell to Overwrite Decimal Separator in Options

[Brett24]

Hi,

My Excel is currently configured to use system separators which are "."
for decimals and "," for thousands. I have a few cells in one
spreadsheet which require the decimal to be "," the reset of the cells
in the spreadsheet need to remain as "." for the decimal separator.

For example currently the cells display:

0.68777777

I would like it to be formatted to display

0,6877777

I am sure there is an easy answer but I cannot seem to find it.

Please help!

Kind Regards,

Brett

 

[Bob Phillips]

If it is okay to be text

=INT(E1)&","&MOD(E1,1)*10^(LEN(MOD(E1,1))-2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)