Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an end-user that when she types a value such as 150100 into a cell, in
any cell of any spreadsheet of any workbook, she will get a result of 150 or 150.1 but the formatting on the cell is set to General and we tried Number. What other settings would affect a number value of a cell and how it's formatted? Also, I checked for templates and found none. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi
check this.... 2003 on the menu bar... toolsoptionsedit tabuncheck fixed decimal paces. regards FSt1 "rbharris" wrote: I have an end-user that when she types a value such as 150100 into a cell, in any cell of any spreadsheet of any workbook, she will get a result of 150 or 150.1 but the formatting on the cell is set to General and we tried Number. What other settings would affect a number value of a cell and how it's formatted? Also, I checked for templates and found none. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excell 2003 format cells | Excel Discussion (Misc queries) | |||
Cell Format Issue | Excel Discussion (Misc queries) | |||
Format of Cell an Issue | Excel Worksheet Functions | |||
Cell shading issue on EXCEL 2003 | Excel Discussion (Misc queries) | |||
Cell shading issue on EXCEL 2003 | Excel Discussion (Misc queries) |