Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
There is a PC here that when in Excel and in Word.... the user types in the
numbers 2004 and then a period or any other key besides a numeric value, the 2004 turns into a .04. If I select the cell and format to anything (number/type/general/etc), that does not change this auto type format that is occuring. The format type that we are looking to use is $. I have checked to see if any macros are being applied... but it doesn't seem that there is. If I can clarify, I will be happy to do so. Thanks, Martin |
#2
![]() |
|||
|
|||
![]()
Hi
check out tools / autocorrect and see if there is an entry for 2004 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "sportmarty" wrote in message ... There is a PC here that when in Excel and in Word.... the user types in the numbers 2004 and then a period or any other key besides a numeric value, the 2004 turns into a .04. If I select the cell and format to anything (number/type/general/etc), that does not change this auto type format that is occuring. The format type that we are looking to use is $. I have checked to see if any macros are being applied... but it doesn't seem that there is. If I can clarify, I will be happy to do so. Thanks, Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
formatting numbers | Excel Worksheet Functions | |||
highlighting cells which have dates later than... | Excel Discussion (Misc queries) | |||
Why does 26000 display as 260.00 after formatting for numbers | Excel Discussion (Misc queries) | |||
Help with Charting My Data -- | Charts and Charting in Excel |