Is there a way to have 25,000.00 show in the cell as 25 and still have it calculate as 25,000.00?
M Millie Jun 15, 2006 #1 Is there a way to have 25,000.00 show in the cell as 25 and still have it calculate as 25,000.00?
N Nikki Jun 15, 2006 #2 go to format--> customer format--->copy and paste--> _(* #,##0.0,_);_(* (#,##0.0,);_(* "-"?_);_(@_)
M Millie Jun 15, 2006 #3 Thank you. That worked. Nikki said: go to format--> customer format--->copy and paste--> _(* #,##0.0,_);_(* (#,##0.0,);_(* "-"?_);_(@_) Click to expand...
Thank you. That worked. Nikki said: go to format--> customer format--->copy and paste--> _(* #,##0.0,_);_(* (#,##0.0,);_(* "-"?_);_(@_) Click to expand...
