Rogue cell adding extra characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I'm tracking job numbers in Excel, and one cell only seems to add 3 zeros
and % sign to any number I enter. How do I fix this?
thanks much!
Mitch
 
Hi Naloorider,
I'm tracking job numbers in Excel, and one cell only seems to add 3 zeros
and % sign to any number I enter. How do I fix this?
Click to expand...

Change the number format of the cell from percentage to general (or to the same
as the cell above it) by rightclicking the cell and choosing Format Cell.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
Extra spaces in a copy/paste from Excel into Word as a link with HTML formatting 0
Excel Drag autofill only part of formula 3
Adding recognised Zeros 5
Excel How to add numbers in same cell? 2
Substituting CRLF with "+" - Transforming a cell containing numbersin a sum of its numbers 2
Default number format in Excel 1
Data Validation error (XL2003 and XL2007) 1

Back
Top