Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi i input data onto a spreadsheet to record the pass marks ie 101/110 92%
5 44/50 88% 4 40/40 100% 8 77/80 96% 9 77/90 86% 2 3/5 60% the one that i entererd in last should read 12/20 but it keeps changing the format to a date or 3/5 I have tried to clear all formats and re enter. I have also tried to format the cells to different formats including General, fraction and custom ?/? and it still keeps putting in a date 12 dec or other figures that do not equate to 12/20 can anyone advise me what i need to do to stop this from happening. -- Thank you for reading my post. Hopefully you can answer my querie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing number format | Excel Worksheet Functions | |||
Changing Cell format | Excel Discussion (Misc queries) | |||
changing date format | New Users to Excel | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) |