Jeffrey Green
Well-known Member
- Joined
- Oct 24, 2007
- Messages
- 1,021
i have data that comes to me as
12345
1234567
12345678, etc.
Those need to $, 2 decimals, so they should be:
$123.45
$12345.67
$123456.78
(I can live without the $ sign)
When i use Custom format $#.##,
the numbers round up. 12345 becomes $123.46, etc.
I would like to use a custom format, but i am not against a macro.
Thanks everyone, be safe.
Jeff
12345
1234567
12345678, etc.
Those need to $, 2 decimals, so they should be:
$123.45
$12345.67
$123456.78
(I can live without the $ sign)
When i use Custom format $#.##,
the numbers round up. 12345 becomes $123.46, etc.
I would like to use a custom format, but i am not against a macro.
Thanks everyone, be safe.
Jeff