View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brett24 Brett24 is offline
external usenet poster
 
Posts: 4
Default Format Cell to Overwrite Decimal Separator in Options

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