Problem with #name

  • Thread starter Thread starter Khong Yew Joon
  • Start date Start date
K

Khong Yew Joon

Dear All ,

I am having a problem with the excel. In column 2, I have a set of
data which consists of two data
1) "- Cardburry Taste Good (C)"
2) "- Cardburry Taste Bad (M)"
3) "- Cardburry Taste Moderate (K)"

When I open the csv files in excel , the data 2) and 3) converted to
"#name?" but data 1) is ok. I have made some research if i replace
data 2) and 3) with (C) to replace with (M) and (K) ,Everthing is fine
..
My question is what is (C) ? Is it a excel formula ?

Looking forward for your kindly answer
Thanks
Ujoon
 
Hi
the problem is the minus sign at the beginning. Try one of the
following:
- format your cells as 'Text' (goto 'Format - Cells')
- enter a leading apostrophe. e.g.
'- Cardburry Taste Good (C)
 
Back
Top