| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing to a usable format - number
I have the following problems:
I have a "number" written as 1,000.00 - however I need to convert it in 1.000,00 (whereby ful stop is a thousands seperator and a comma is a decimal seperator ) the second number is written as 1,000M whereby M means 1000 therefore the number should be equal to 1.000.000 how could i convert the numbers in useful formats? thanks for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Import Wizard - Changing number format | Excel Discussion (Misc queries) | |||
| Changing Phone number format | Excel Worksheet Functions | |||
| copying info from one cell to another, changing the format, but leaving the number | Excel Worksheet Functions | |||
| Changing number format | Excel Worksheet Functions | |||
| Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
Threaded Mode
