Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
sportmarty
 
Posts: n/a
Default Formatting: when typing the numbers "2004" then a period or simili

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   Report Post  
JulieD
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com Excel Worksheet Functions 33 April 4th 05 02:17 PM
formatting numbers jonas Excel Worksheet Functions 3 February 16th 05 06:12 PM
highlighting cells which have dates later than... Rory Carroll Excel Discussion (Misc queries) 6 February 3rd 05 11:39 PM
Why does 26000 display as 260.00 after formatting for numbers shiv Excel Discussion (Misc queries) 1 January 31st 05 10:13 AM
Help with Charting My Data -- DavidM Charts and Charting in Excel 7 January 7th 05 01:08 PM


All times are GMT +1. The time now is 11:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"