Changing number format to ten thousands

[kirkley08]

Hi, I have loads of data in numbers and I want to change it to the format of ten thousands.
For example:
20,000 = 2.00
200,000 = 20.00
65,887 = 6.59
894,021 = 89.40

I've been searching for the answer but only for thousands and milions.

 

[nemmi69]

go to custom format and enter "#," with out the speech marks

 

[kirkley08]

go to custom format and enter "#," with out the speech marks

Hi Nemmi, have tried it but the result is not the one that I wanted. If the number is 35,250 with the format you gave just now, it will become 35.
I want it to be 3.53

 

[nemmi69]

In that case use "#,###"

 

[kirkley08]

In that case use "#,###"

it shows like this instead of 3.53

 

[nemmi69]

seems to be "0.###,"

 

[awoohaw]

i think this custom format works (this is US punctuation):

 

[kirkley08]

@nemmi69 @awoohaw
Here attached the minisheet to ease you good sirs.
I want to convert it to a number per ten thousands, not thousands.

Dummy.xlsx
	A	B
1	Original Number	Ten thousands format
2
3	65,525	6.55
4	48,752	4.88
5	58,550	5.86
6	187,985	18.80
Sheet1

 

[awoohaw]

@nemmi69 @awoohaw
Here attached the minisheet to ease you good sirs.
I want to convert it to a number per ten thousands, not thousands.

Dummy.xlsx
	A	B
1	Original Number	Ten thousands format
2
3	65,525	6.55
4	48,752	4.88
5	58,550	5.86
6	187,985	18.80
Sheet1

i'm sorry I missed that. i don't think you can get the number format to "break" at points not in the typical 3rd position. Maybe there is a way in VBA but, i'm not expert at that.

 

[Joe4]

Why not just divide the value in column A by 10000 and format as a number with two decimal places, i.e.
formula to put in cell B2:

=A2/10000