| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel row entry
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel row entry
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 -- Kevin Backmann "ravenpeyton" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| data entry in excel by linking to other word doc. or excel sheets | Excel Worksheet Functions | |||
| Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions | |||
| Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions | |||
| Display Last Entry in Excel | Excel Worksheet Functions | |||
Linear Mode
