LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 427
Default International decimal number formats

John-
I typed some decimal numbers and they appeared on-screen with my
default settings: a period as decimal. Then I clicked ~Start ~Control
Panel Regional and Language Options and clicked the Custom button.
This allowed me to show my decimal places with a comma; the numbers I
had already entered were converted automatically.

So it sounds like no conversion is required at all: if you're
exchanging spreadsheets with places that use a comma to denote the
decimal place, they will likely have their preferences set in Control
Panel. No additional effort would be required.

I also tried as many ideas as I could to perform your desired
conversion, and did in fact generate a way to do it. However, it would
include entering numbers in a particular column and then hiding that
column; somewhere in the workbook you could have a "user preferences"
section where the user enters a P for period and a C for comma. Then
in a helper column right next to the hidden column enter a formula,
perhaps something like this:
=IF(A1="C",INT(C11)&","&TEXT(INT(MOD(C11,1)*100)," 00"),C11)
....where A1 is the P or C column, and C11 is a hidden numeric entry
column. The problem with this idea, or should I say "among the handful
of problems" for there are many: this creates a text entry, so you
cannot perform math on it, and it's just generally chunky and ugly and
inelegant.

What do you think about the Regional and Language Options idea? And
just for curiosity, what is your timezone? I am on the East Coast of
the USA, GMT -5

Dave O

 
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
excel question Formats and number pad raindancer Excel Discussion (Misc queries) 1 February 8th 06 02:36 AM
" / " Changing Decimal number format to Fraction on Protected Cell laudie Excel Worksheet Functions 0 November 15th 05 02:13 AM
" / " Changing Decimal number format to Fraction on Protected Cell laudie Excel Worksheet Functions 0 November 15th 05 01:12 AM
International number separator bibi Excel Worksheet Functions 0 August 3rd 05 06:49 PM
number formats default to 2 decimal points when entered so 24 bec. kiddo7us Excel Discussion (Misc queries) 1 March 30th 05 09:48 AM


All times are GMT +1. The time now is 05:57 PM.

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"