| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet/table entered numbers are rewritten!
I enter the numbers "06-9832" which are then automatically changed to
"Jun-32". Why and how do I turn off this function / formatting? Many thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet/table entered numbers are rewritten!
Precede it with a single apostrophe, ', or format the cell as text.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "OldFatDog" wrote in message ... I enter the numbers "06-9832" which are then automatically changed to "Jun-32". Why and how do I turn off this function / formatting? Many thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet/table entered numbers are rewritten!
You can change the format of the cell to "Text", if you're application will allow you to treat those numbers as text strings. Format Cells Number == Text HTH Bruce -- BruceP ------------------------------------------------------------------------ BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653 View this thread: http://www.excelforum.com/showthread...hreadid=536901 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Avoid duplicate number entry when only start and stop numbers given. | Excel Discussion (Misc queries) | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| in excel why do numbers entered get divided by 100? | Excel Discussion (Misc queries) | |||
Linear Mode
