ExcelBanter - How do I format currency field in Excel 2000 w/o 2 extra zeroes?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I format currency field in Excel 2000 w/o 2 extra zeroes? (https://www.excelbanter.com/excel-discussion-misc-queries/34861-how-do-i-format-currency-field-excel-2000-w-o-2-extra-zeroes.html)

slmm

How do I format currency field in Excel 2000 w/o 2 extra zeroes?

--
May the Good Lord be with You and His Guiding Light be strong...

Barb Reinhardt

Format Cells - Currency - select decimal places 0??
"slmm" wrote in message
...

--
May the Good Lord be with You and His Guiding Light be strong...

slmm

Thanks Barb. I tried that but then I only have the dollar amount and no
decimals and no cents.
--
May the Good Lord be with You and His Guiding Light be strong...

"Barb Reinhardt" wrote:

Format Cells - Currency - select decimal places 0??
"slmm" wrote in message
...

--
May the Good Lord be with You and His Guiding Light be strong...

All times are GMT +1. The time now is 10:47 PM.