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.