Excel row entry

  • Thread starter Thread starter ravenpeyton
  • Start date Start date
R

ravenpeyton

I type in 5E0102 in an Excel row and it comes up as ####### on a spreadsheet
I'm working on. The previous 200 or so entries are OK. What have I done or
what did the person who sent me this spreadsheet do to cause the remaining
rows to do this?
 
Excel has assumed that the value you have entered is in scientific notation.
To correct this you can do one of the following:

1. Type an apostrophe before entering the text to make it a label
2. Delete the current entry and format the cell(s) for text and then
reenter the value
 
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

Autofilter header row 3
Excel Visual Basic to get current row number 1
Conditiontal linking between spreadsheets 3
Question on the occupied field of the pivot table in excel spreadsheet 0
setting row height not to exceed... 1
Why does my excel to word mail merged doc not merge last entry? 3
Remove date format? 3
If function not working correctly 15

Back
Top