View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Unnecessary conversion

Hi All,

I have a normal XL file generated by an application as output. There are
cells in it containing decimal numbers stored as text, e.g. "5.2".
When Opening this file XL converts strings recognizable as a date to dates,
like 2007/5/2.
What can I do to keep the original string "5.2" or convert it to a real
decimal number?

Regards,
Stefi