#1
|
|||
|
|||
Format 1,234.56 instead 1.234,56
I tried to format 1,234.56 instead 1.234,56 just Find-Replace but doesen't help.
Help me. I use Office 2010. |
#2
|
||||
|
||||
The number formats that are supported are determined by your system's regional settings. Change yours to a UK/US/Aus regional setting, for example, and the numbers will re-format themselves.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I set it, but it's not a solution to my problem. :/
|
#4
|
||||
|
||||
Is it a real number or text looking like a number?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
A1 is misformatted number as per example.
B1 =VALUE(SUBSTITUTE(SUBSTITUTE(A1,".",","),",",".",2 )) Format B1 as number and select 1000's seperator |
#6
|
||||
|
||||
That will neither correct the original number in-situ nor address a number formatting issue - it will only work with numeric text. It also won't work with numeric text numbers less than 1000 or greater than 999999.99
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
What is your normal:
Decimal separator Thousand separator? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
format 00:00:00: AM and not 00:00 | habiler | Word | 3 | 03-05-2015 12:56 PM |
Format Painter doesn't work on Table Format? | Joey Cheung | Word Tables | 1 | 08-20-2014 02:24 AM |
1.image in a table 2.right click 3.menu click format 4.a format column appears | OldFatDog | Drawing and Graphics | 1 | 06-13-2014 11:19 PM |
Change from General Format to number format | gbaker | Excel | 3 | 08-16-2013 01:04 PM |
Format a Row | Eagle710 | Excel | 0 | 08-05-2009 08:57 AM |