Excel Spreadsheet

  • Thread starter Thread starter Andy
  • Start date Start date
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?
 
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".
 
Back
Top