Thread: Why 28E50 changes to 2.80E+51
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Why 28E50 changes to 2.80E+51
Need to format as Text before entering the value.
--
Gary's Student
gsnu200708


"Mary" wrote:

Please help Why 28E50 changes to 2.80E+51. I tried to format them as text and
does not work.

Reply With QuoteReply With Quote