| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
large numbers as text replaced with scientific notation
I did a search-and-replace to remove spaces from a column of 16-digit
credit card numbers stored in cells formatted as text, but afterwards, the numbers appeared as scientific notation. If I then select each cell in turn and click in the formula bar, the scientific notation goes away, but the last digit of each string is replaced with zero. How can I use search-and-replace to remove spaces without altering the strings of digits or truning them into scientific notation? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show value as text not scientific notation | Excel Discussion (Misc queries) | |||
| Hex numbers displayed in scientific notation when importing text f | Excel Discussion (Misc queries) | |||
| Scientific notation in text cells | Excel Discussion (Misc queries) | |||
| Using scientific notation in TEXT() function | Excel Worksheet Functions | |||
| Long numbers show up as Scientific Notation | Excel Discussion (Misc queries) | |||
Threaded Mode
