how to convert a number which is taken as a formula to an alpha numeric character

Originally Posted by bhashini.s

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,

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
---