Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
how do I keep 16 digit numbers as text in excel?
I format the cells as text ahead of time but when I cut and paste the numbers in the last digit is converted to a zero and it is displayed in scientific notation. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
numbers and text in Excel to read as text keeping the leading zer. | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
I enter numbers and they are stored as text | Excel Discussion (Misc queries) |