| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to stop fractions in a columm automatically changing to dates
Just trying to enter 5/5 into a cell. But automatically changes to 5-may.
How do I sto that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to stop fractions in a columm automatically changing to dates
put an apostrophe in front '05/05 or format the cell as a date.
-- Gary Keramidas Excel 2003 "John" wrote in message ... Just trying to enter 5/5 into a cell. But automatically changes to 5-may. How do I sto that? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to stop fractions in a columm automatically changing to dates
Either pre-format the cell as TEXT or, precede the entry with an apostrophe
like this '5/5. -- Biff Microsoft Excel MVP "John" wrote in message ... Just trying to enter 5/5 into a cell. But automatically changes to 5-may. How do I sto that? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to stop fractions in a columm automatically changing to dates
--Right click the cell/rangeFormat CellsCustom Type
0/0 If this post helps click Yes --------------- Jacob Skaria "John" wrote: Just trying to enter 5/5 into a cell. But automatically changes to 5-may. How do I sto that? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to stop fractions in a columm automatically changing to dates
Doesn't that display as 39938/1 rather than 5/5 ?
Formatting as d/m would display as 5/5, but of course it would still be a date. -- David Biddulph "Jacob Skaria" wrote in message ... --Right click the cell/rangeFormat CellsCustom Type 0/0 If this post helps click Yes --------------- Jacob Skaria "John" wrote: Just trying to enter 5/5 into a cell. But automatically changes to 5-may. How do I sto that? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to stop fractions in a columm automatically changing to da
Thanks David.. I mean to say preformat the cells. But still it would display
5/5 as 1/1.. If this post helps click Yes --------------- Jacob Skaria "David Biddulph" wrote: Doesn't that display as 39938/1 rather than 5/5 ? Formatting as d/m would display as 5/5, but of course it would still be a date. -- David Biddulph "Jacob Skaria" wrote in message ... --Right click the cell/rangeFormat CellsCustom Type 0/0 If this post helps click Yes --------------- Jacob Skaria "John" wrote: Just trying to enter 5/5 into a cell. But automatically changes to 5-may. How do I sto that? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to stop fractions in a columm automatically changing to dates
Try entering an inverted comma before the fraction.
'5/5 Or did you want Excel to evaluate the fraction? if so place an equals sign first =5/5 -- Steve "John" wrote in message ... Just trying to enter 5/5 into a cell. But automatically changes to 5-may. How do I sto that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel converts fractions into dates. Make it stop. | Excel Discussion (Misc queries) | |||
| How do I stop the font from changing colour automatically? | Excel Discussion (Misc queries) | |||
| Need to stop formuls from automatically changing | Excel Discussion (Misc queries) | |||
| stop automatically changing fomula ... | Excel Worksheet Functions | |||
| How do I keep excel 2002 from changing fractions to dates? | Excel Discussion (Misc queries) | |||
Hybrid Mode
