Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
general date to date format
Hi
Please help I have tried all the formulas in the other post but none work. I either get a circular error or shows #ref or #format. My dates look like 03-JAN-98 I need them to be date format like 01/03/98 or 01/03/1998. I will be importing into vfp8 and need it to be in date format. Thanks Sherry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
general date to date format
Select the cells or entire column. Right click, select Format Cells ,In the
Category select Custom. Under Type type in mm/dd/yy or mm/dd/yyyy Hope this helps "sherry" wrote: Hi Please help I have tried all the formulas in the other post but none work. I either get a circular error or shows #ref or #format. My dates look like 03-JAN-98 I need them to be date format like 01/03/98 or 01/03/1998. I will be importing into vfp8 and need it to be in date format. Thanks Sherry |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
general date to date format
They must be seen as text, first make sure you have a date format like
mm/dd/yyyy, then select the column and do datatext to columns and click finish. -- Regards, Peo Sjoblom "sherry" wrote in message ... Hi Please help I have tried all the formulas in the other post but none work. I either get a circular error or shows #ref or #format. My dates look like 03-JAN-98 I need them to be date format like 01/03/98 or 01/03/1998. I will be importing into vfp8 and need it to be in date format. Thanks Sherry |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
general date to date format
Sorry I seem to have misread the question but why would you get a circular
reference warning if you just try to format the value? Not possible unless you have a formula. Btw there is no #format error to my knowledge.also don't refer to some other post it's better to post in the same thread. -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... They must be seen as text, first make sure you have a date format like mm/dd/yyyy, then select the column and do datatext to columns and click finish. -- Regards, Peo Sjoblom "sherry" wrote in message ... Hi Please help I have tried all the formulas in the other post but none work. I either get a circular error or shows #ref or #format. My dates look like 03-JAN-98 I need them to be date format like 01/03/98 or 01/03/1998. I will be importing into vfp8 and need it to be in date format. Thanks Sherry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format for general formatting | Excel Discussion (Misc queries) | |||
Converting general text format to date | Excel Discussion (Misc queries) | |||
all the general formats suddenly replaced with date format. | Excel Discussion (Misc queries) | |||
CSV Date Format and General Arrrggghhh-ness | Excel Discussion (Misc queries) | |||
How do I stop a general format from being autoformatted to date | New Users to Excel |