View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Asheret Asheret is offline
external usenet poster
 
Posts: 3
Default format text as number

I am trying to convert celss which include both numbers and text, which I
have imported. (I think from a LOTUS 123 programme) I have used both
'REPLACE' and SUBSTITUTE' but the number remaining are still treated as text
and will not accept formats. Please Someone...HELP. Thx Ash
--
Asheret