Thread: HTML to Excel
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try:
- copy an empty cell
- select your imported numbers
- goto Edit - Paste Special and choose 'Add'

--
Regards
Frank Kabel
Frankfurt, Germany

"Billing Goddess" schrieb im
Newsbeitrag ...
I have saved an HTML document as an Excel document. I am trying to

insert a
formula that uses the some of the figures listed on the excel

document, but
the formulas return a #value! error. Is this because the figures that

were
once html are now not recognized in excel? Formatting the figures

does not
work, but if I retype the figure, the formula works. Any

suggestions??
--
Many Thanks,
Paula