Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've tried to change to format of a cell to be general so that I can show for
example 10/35. The cell keeps reverting back to the date format. what do I need to do so that it shows exactly as i type it? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
##/## as the custom format
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "lsmith" wrote in message ... I've tried to change to format of a cell to be general so that I can show for example 10/35. The cell keeps reverting back to the date format. what do I need to do so that it shows exactly as i type it? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I tried it, but it reduced the fraction to the lowest common denominator. How
do I make show exactly as typed? "Bob Phillips" wrote: ##/## as the custom format -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "lsmith" wrote in message ... I've tried to change to format of a cell to be general so that I can show for example 10/35. The cell keeps reverting back to the date format. what do I need to do so that it shows exactly as i type it? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Format the cell as text before you enter the data.
-- David Biddulph "lsmith" wrote in message ... I tried it, but it reduced the fraction to the lowest common denominator. How do I make show exactly as typed? "Bob Phillips" wrote: ##/## as the custom format "lsmith" wrote in message ... I've tried to change to format of a cell to be general so that I can show for example 10/35. The cell keeps reverting back to the date format. what do I need to do so that it shows exactly as i type it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting Cells | Excel Worksheet Functions | |||
Formatting cells | Excel Discussion (Misc queries) | |||
Formatting cells | New Users to Excel | |||
Formatting Cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions |