Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Cell to Overwrite Decimal Separator in Options
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) "Brett24" wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
I want to format a number cell without the decimal and without ro. | Excel Discussion (Misc queries) | |||
Format a cell to display decimal hours. | Excel Discussion (Misc queries) |