| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
THANK YOU SOOOOO MUCH!
"David Biddulph" wrote: Tools/ Options/ Edit/ Unset Fixed decimal places -- David Biddulph "pm hudson" wrote in message ... For example....when I key 109 into a cell, it returns 0.00109. All numbers are converted in this way. It adds 0.00 to each number entered. Even when changing the formatting, it still returns the same number. "Rick Rothstein (MVP - VB)" wrote: When I key numbers into a cell, the format returned is not what is keyed in....and no matter what format I change it too, it stays the same. HELP!! It would really help if you told us what numbers you were keying in, what "format" you were seeing for it and what "format" you were expecting to see. Otherwise, we cannot know what your problem is. Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
![pm hudson[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
