| Home |
| Search |
| Today's Posts |
|
#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? |
| 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) | |||
Threaded Mode
