Home |
Search |
Today's Posts |
#1
|
|||
|
|||
format cells
in an Excel 2002 sheet we have cells with general format and we put in
numbers like this one: 6/1. A lot of people have access to this file Someone changed some of the cells into a date format: 06-Jan-05 Unfortunately our backup is also corrupt. Is there a way to revert this back? |
#2
|
|||
|
|||
Not "someone", but Excel, when using Excel 2002 SP3 in any case. If you want
to use fractions, you have to format as fractions, or else for numbers like 6/1, you have to precede it with an apostrophe ('). To convert back to what you want, where the date is 06-Jan-05, then obviously the correct format is '6/1, while 09-Jan-05 will convert to '9/1. "Alfred" wrote: in an Excel 2002 sheet we have cells with general format and we put in numbers like this one: 6/1. A lot of people have access to this file Someone changed some of the cells into a date format: 06-Jan-05 Unfortunately our backup is also corrupt. Is there a way to revert this back? |
#3
|
|||
|
|||
I *suppose* you could try this, where the entries are now dates:
You'll need two empty columns - one for the TEXT() formula below, and another column that is FORMATTED as text. If the date is in A1, and using your example where 6/1 was converted into Jan-6-05 =text(A1,"d/m") will give you 6/1 as a formula result. Copy it, and Paste Special Values into the column that is formatted as text. Good luck Duke "Alfred" wrote: in an Excel 2002 sheet we have cells with general format and we put in numbers like this one: 6/1. A lot of people have access to this file Someone changed some of the cells into a date format: 06-Jan-05 Unfortunately our backup is also corrupt. Is there a way to revert this back? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My sheet is unprotected, but I can't format cells. | Excel Discussion (Misc queries) | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Format cells as date | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions |