| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Symbol - point needed
Hello,
I'm using the comma as decimal symbol (norwegian regional settings), but for 1 cell in my spreadsheet, I need the value to display with the point as the decimal symbol. I know the decimal symbol can be changed in Excel when changing the regional settings to US, but I only need this one cell to display the point as decimal symbol. Creating a custom number (####.##) in Format cells does not allow me use that number format. Does anyone know how to do this? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Decimal Symbol - point needed
=SUBSTITUTE(TEXT(A1;"0,00");",";".")
-- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message oups.com... | Hello, | | I'm using the comma as decimal symbol (norwegian regional settings), | but for 1 cell in my spreadsheet, I need the value to display with the | point as the decimal symbol. I know the decimal symbol can be changed | in Excel when changing the regional settings to US, but I only need | this one cell to display the point as decimal symbol. | Creating a custom number (####.##) in Format cells does not allow me | use that number format. | Does anyone know how to do this? | Thanks! | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Merge without having decimal point move? | Excel Discussion (Misc queries) | |||
| Show decimal point only if not a whole number | Excel Discussion (Misc queries) | |||
| decimal point | Excel Worksheet Functions | |||
| In excel, how can i delete 1 digit and the decimal point? | Excel Worksheet Functions | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
Hybrid Mode
