| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting of values
Hi All,
When I type any figures into an excel spreadsheet the format doesn't appear quite correct. For example for ‚¬12.00 I get ‚¬12,00 how can I change it so I get a decimal point (.) not a comma symbol (,). Thanks for the help ;-) Andy. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting of values
What version Excel are you using. Unable to duplicate your issue.
"Andy" wrote: Hi All, When I type any figures into an excel spreadsheet the format doesn't appear quite correct. For example for ‚¬12.00 I get ‚¬12,00 how can I change it so I get a decimal point (.) not a comma symbol (,). Thanks for the help ;-) Andy. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting of values
Could be a Windows Regional Settings function where you have the comma set as
decimal separator. Or in Excel you may have changed that setting in ToolsOptionsInternational under "Number Handling" Gord Dibben MS Excel MVP On 7 Mar 2007 14:02:35 -0800, "Andy" wrote: Hi All, When I type any figures into an excel spreadsheet the format doesn't appear quite correct. For example for €12.00 I get €12,00 how can I change it so I get a decimal point (.) not a comma symbol (,). Thanks for the help ;-) Andy. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting values to be Times of day... | Excel Discussion (Misc queries) | |||
| Formatting month values | Excel Worksheet Functions | |||
| Formatting multiple values | Excel Discussion (Misc queries) | |||
| 3 highest values indicated using formatting | Excel Worksheet Functions | |||
| Values w/conditional formatting | Excel Worksheet Functions | |||
Linear Mode
