Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks!
"Peo Sjoblom" wrote: Preformat as fractions and then enter as fractions should do it If you don't intend to do any calculation you might be better off formatting as text before you enter them or precede any entry with an apostrophe -- Regards, Peo Sjoblom "Roxanne" wrote in message ... When entering fractions in a spreadsheet what do you add before a fraction so that Excel does not recognize it as a date? Somebody gave me this symbol //. Thanks for any help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I have excel convert fractions to decimals? | Excel Worksheet Functions | |||
Excel reduces fractions | Excel Discussion (Misc queries) | |||
Formatting Numbers and Fractions in Excel | Excel Discussion (Misc queries) | |||
Entering and displaying fractions | Excel Worksheet Functions | |||
fractions in excel | Excel Discussion (Misc queries) |