how do i enter alpha numeric numbers such as
-98hjuh7
=ij8976h
as just alphanumeric number and not as formula
as the file is sent in csv format from unix and opened in excel sheet formatting the cell as "text" is not possible
how do i enter alpha numeric numbers such as
-98hjuh7
=ij8976h
as just alphanumeric number and not as formula
as the file is sent in csv format from unix and opened in excel sheet formatting the cell as "text" is not possible
Hi,Originally Posted by bhashini.s
Two possibilities, Copy the file contents from Notepas and Paste to A1, then Data, Text to Columns, OR, rename the file to .txt and open through the wizard.
hth
---
Si fractum non sit, noli id reficere.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks