| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering numbers in the cells in excel
when entering numbers into a cell, how do you change the format from it
automatically changing the numbers inputted into date formats ? for example: 7-3 gets changed to 3-Jul. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
entering numbers in the cells in excel
The easiest way is to precede the 7-3 with an apostrophe ('). Then Excel will
not modify it. You could also preformat the cells to text, which will stop Excel from changing them. -- Regards, Fred "jsal" wrote in message ... when entering numbers into a cell, how do you change the format from it automatically changing the numbers inputted into date formats ? for example: 7-3 gets changed to 3-Jul. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel viewer | Setting up and Configuration of Excel | |||
| Excel auto formats cells with numbers - Can it be disabled? | Setting up and Configuration of Excel | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
| How to alter data on HTML webpage into Excell cells as numbers? | New Users to Excel | |||
Linear Mode
