'Excel formatting - Integers with decimal point and thousand separator
All the data that come from the source are integers:
345819404
1093
28495
The only "tool" I have at my hand is Excel-style formatting options to turn it into:
3,458,194.04
10.93
284.95
Basically I can't convert those using / 100. So far I have two different styles that give me both components but I can't merge them together.
#,##0 gives me thousand separator
#"."00 places the dot as a "fake" decimal point
How can I get this work together?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
