Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use the number format
Everytime i type in 9 - 2 it automatically changes to 09- feb. i changed the
number format to general but it keeps changing back to custom. how can i fix this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use the number format
Prefix an apostrophe.
'9-2 If this post helps click Yes --------------- Jacob Skaria "newbie101" wrote: Everytime i type in 9 - 2 it automatically changes to 09- feb. i changed the number format to general but it keeps changing back to custom. how can i fix this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use the number format
Change the cell's format to Text (or precede the entry with an apostrophe...
it won't print and the entry will be text). -- Rick (MVP - Excel) "newbie101" wrote in message ... Everytime i type in 9 - 2 it automatically changes to 09- feb. i changed the number format to general but it keeps changing back to custom. how can i fix this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use the number format
On Tue, 25 Aug 2009 21:42:01 -0700, newbie101
wrote: Everytime i type in 9 - 2 it automatically changes to 09- feb. i changed the number format to general but it keeps changing back to custom. how can i fix this? What do you want the result to be? If you want the cell to display 9 - 2 then enter '9 - 2 If you want the cell to display 7 then enter =9-2 Hope this helps / Lars-Åke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |