| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format a cell
I have an excel spreadsheet that I use to track data. When I went to enter
the data , 10/50, into the cell, it is changed to Oct 50. It is formatted the same as previous cells and they don't make the change. I tried changing the format to allow fractions, but then it changes it to 1/5. Does anyone know how to fix this so that it reads the 10/50???? Thanks for any advice that can be given! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a cell
'10/50
the single quote will avoid the misinterpretation but will not be visible or affect use of the data in the cell. -- Regards, Tom Ogilvy "Tia" wrote: I have an excel spreadsheet that I use to track data. When I went to enter the data , 10/50, into the cell, it is changed to Oct 50. It is formatted the same as previous cells and they don't make the change. I tried changing the format to allow fractions, but then it changes it to 1/5. Does anyone know how to fix this so that it reads the 10/50???? Thanks for any advice that can be given! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a cell
Or format the cell as text before you enter the number.
-- David Biddulph "Tom Ogilvy" wrote in message ... '10/50 the single quote will avoid the misinterpretation but will not be visible or affect use of the data in the cell. "Tia" wrote: I have an excel spreadsheet that I use to track data. When I went to enter the data , 10/50, into the cell, it is changed to Oct 50. It is formatted the same as previous cells and they don't make the change. I tried changing the format to allow fractions, but then it changes it to 1/5. Does anyone know how to fix this so that it reads the 10/50???? Thanks for any advice that can be given! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Linear Mode
