Excel Spreadsheet

A

Andy

Issue: The value shown in the status box shows 6147; cell
is formated with commas, 6,147; value in cell shows
64147. Any ideas?
 
R

RWN

I assume you mean the cell = 6147 (vs. 64147).
Sounds like the value was placed in the cell as text.
Even if you attempt to format it as a numerically formatted cell after
the fact it will remain as text.
Try selecting the cell and "F2" then "Enter".
 
Top