Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell formats
For some reason my Excel program has changed the format on Phone numbers. For example when I set a cell to use the phone number format it should take the numbers 1234567890 and show them in the cell as (123) 456-7890 but they don't. They now show in the cell as (1) 234-5678 can anybody tell me how to fix this. Also, I have noticed another change ie., I in a cell I enter 9. it will come out as 0.09 Any suggestions? -- Jecakias ------------------------------------------------------------------------ Jecakias's Profile: http://www.excelforum.com/member.php...o&userid=20115 View this thread: http://www.excelforum.com/showthread...hreadid=346873 |
#2
|
|||
|
|||
Uncheck the Fixed decimal places checkbox in Tools/Options/Edit
In article , Jecakias wrote: For some reason my Excel program has changed the format on Phone numbers. For example when I set a cell to use the phone number format it should take the numbers 1234567890 and show them in the cell as (123) 456-7890 but they don't. They now show in the cell as (1) 234-5678 can anybody tell me how to fix this. Also, I have noticed another change ie., I in a cell I enter 9. it will come out as 0.09 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I know the no of different cell formats in a Excel workbo. | Excel Discussion (Misc queries) | |||
numeric cell formats | Excel Discussion (Misc queries) | |||
Cell Formats in formulas | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Too Many Different Cell Formats | Excel Worksheet Functions |