LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default fraction into date

hi all members...

I have excel 2007 and when I enter
a number like 6/33 it turns it into
Jun-33.

this number 6/33 is being copy from
one note 2007 and pasted into excel.

I have tried to manipulate it but to no
success and have checked out 'excel options'.

can someone please help.

I thank all for your time and advice and
look forward to a reply.

many many thanks.

Paul.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text fraction to fraction format brownti via OfficeKB.com Excel Worksheet Functions 1 February 1st 08 02:38 PM
How do I convert a fraction to its true decimal, not a date no. 2HatsMcHattie Excel Discussion (Misc queries) 2 October 15th 07 09:25 AM
How do I change fraction to fraction characters? cmcqueary2806 Excel Worksheet Functions 1 November 2nd 06 09:58 PM
date has fraction instead of whole number Shlookonim Excel Discussion (Misc queries) 1 January 27th 06 03:49 PM
fraction getting convered into date bombayterror New Users to Excel 4 January 8th 06 09:27 PM


All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"