| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
numbers and text in Excel to read as text keeping the leading zer.
I am trying to open a CSV file, one column is String but contains numerics
with leading Zero (ex. "00123456"). When I open it in Excel it looses the leading Zeros, how can I keep it ON. I tried to pass the apostrophie ' , but this did not help my problem as it still shows in the cell untill I Edit the cell and re-enter it. Thank you Raouf |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
| I enter numbers and they are stored as text | Excel Discussion (Misc queries) | |||
| Converting text to numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
