ExcelBanter - Number Format

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

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

- - Number Format (https://www.excelbanter.com/excel-discussion-misc-queries/94281-number-format.html)

Millie

Number Format

Is there a way to have 25,000.00 show in the cell as 25 and still have it
calculate as 25,000.00?

Nikki

Number Format

go to format-- customer format---copy and paste--
_(* #,##0.0,_);_(* (#,##0.0,);_(* "-"?_);_(@_)

"Millie" wrote:

Is there a way to have 25,000.00 show in the cell as 25 and still have it
calculate as 25,000.00?

Millie

Number Format

Thank you. That worked.

"Nikki" wrote:

go to format-- customer format---copy and paste--
_(* #,##0.0,_);_(* (#,##0.0,);_(* "-"?_);_(@_)

"Millie" wrote:

Is there a way to have 25,000.00 show in the cell as 25 and still have it
calculate as 25,000.00?

All times are GMT +1. The time now is 03:07 PM.