Does anyone know how to format currency so that it shows without dollar sign
or commas or decimals (without rounding up)

example: $3,059.63 would convert to 305963 and $25.50 would convert to 2550

I've figured out how to get rid of the dollar sign and the comma, but when I
try removing the decimal the number always rounds up.

This is needed for a fixed length file. The system assumes the last 2 digits
to be cents.

Any help would be appreciated.

Thanks you.

You will have to multiply by 100 in a helper column, something like =A1*100
If needed, you can then format that column as 0 decimals. Copy this column,
and paste special as values, then delete the original column
--
Hth

Kassie Kasselman
Change xxx to hotmail


"T''Kai" wrote:

Does anyone know how to format currency so that it shows without dollar sign
or commas or decimals (without rounding up)

example: $3,059.63 would convert to 305963 and $25.50 would convert to 2550

I've figured out how to get rid of the dollar sign and the comma, but when I
try removing the decimal the number always rounds up.

This is needed for a fixed length file. The system assumes the last 2 digits
to be cents.

Any help would be appreciated.

Thanks you.

Type 100 in an empty cell. Select that cell and click copy. Select the
range you wish to remove the decimal from and click Edit, Paste Special or
the list button for Paste, and Paste Special - depending on Excel version.
In the Paste Special dialog box, select Multiply and Click Ok. You can then
delete the 100 you entered earlier.

"T''Kai" wrote:

Does anyone know how to format currency so that it shows without dollar sign
or commas or decimals (without rounding up)

example: $3,059.63 would convert to 305963 and $25.50 would convert to 2550

I've figured out how to get rid of the dollar sign and the comma, but when I
try removing the decimal the number always rounds up.

This is needed for a fixed length file. The system assumes the last 2 digits
to be cents.

Any help would be appreciated.

Thanks you.

It worked! Thank you both very much.

"T''Kai" wrote:

Does anyone know how to format currency so that it shows without dollar sign
or commas or decimals (without rounding up)

example: $3,059.63 would convert to 305963 and $25.50 would convert to 2550

I've figured out how to get rid of the dollar sign and the comma, but when I
try removing the decimal the number always rounds up.

This is needed for a fixed length file. The system assumes the last 2 digits
to be cents.

Any help would be appreciated.

Thanks you.