Thread: How do I convert a fraction to its true decimal, not a date no.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HASSAN SHAREEF[_2_] HASSAN SHAREEF[_2_] is offline
external usenet poster
  
Posts: 5
Default How do I convert a fraction to its true decimal, not a date no.
Check the format of cells where you are impoting data make it number before
you import because by default excel will take those fractional values as
dates.

"2HatsMcHattie" wrote:

I have imported a file into excel with fractions. When I convert the
fractions to decimals, it converts to a date number. e.g. 3/1 converts to
39085 as it sees it not as 3 but as the 3rd January. Any ideas?
Reply With QuoteReply With Quote