#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 170
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting values to be Times of day... Al Gillis Excel Discussion (Misc queries) 3 June 18th 06 12:07 AM
Formatting month values Mo Excel Worksheet Functions 3 January 19th 06 07:35 PM
Formatting multiple values fujimi-cho Excel Discussion (Misc queries) 1 September 6th 05 04:23 PM
3 highest values indicated using formatting John Excel Worksheet Functions 7 May 15th 05 03:26 PM
Values w/conditional formatting Fred Timmons Excel Worksheet Functions 7 January 4th 05 04:31 AM


All times are GMT +1. The time now is 12:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"