Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default when I enter 350 in any worksheet, it converts to 350o WHY?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default when I enter 350 in any worksheet, it converts to 350o WHY?

Sounds like you have a custom format on those cells (FormatCellsCustom).

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ohio Cat" <Ohio wrote in message
...



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,345
Default when I enter 350 in any worksheet, it converts to 350o WHY?

If it only happens with 350 I would look in the Autocorrect list, Tools
AutoCorrect

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Ohio Cat" <Ohio
wrote in message
...




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default when I enter 350 in any worksheet, it converts to 350o WHY?

PERFECT! There it was and now it's not. Wonderful. And a great day to you.

"Sandy Mann" wrote:

If it only happens with 350 I would look in the Autocorrect list, Tools
AutoCorrect

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Ohio Cat" <Ohio
wrote in message
...





  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default when I enter 350 in any worksheet, it converts to 350o WHY?

No, it was the auto-correct thing

"Bob Phillips" wrote:

Sounds like you have a custom format on those cells (FormatCellsCustom).

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ohio Cat" <Ohio wrote in message
...






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,345
Default when I enter 350 in any worksheet, it converts to 350o WHY?

Glad that it worked for you. Now look around the office and se if anyone is
smiling.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Ohio Cat" wrote in message
...
PERFECT! There it was and now it's not. Wonderful. And a great day to
you.

"Sandy Mann" wrote:

If it only happens with 350 I would look in the Autocorrect list, Tools
AutoCorrect

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Ohio Cat" <Ohio
wrote in message
...








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
Enter number on a worksheet to copy row from another worksheet 1SG Excel Worksheet Functions 1 May 22nd 07 12:15 AM
When I enter a date in Excel it converts to a 5-digit number. WHY? Wendy@EIS Excel Discussion (Misc queries) 1 January 8th 07 09:32 PM
Array Pasted from One Worksheet Converts Null Values to Zeros BK Waas Excel Discussion (Misc queries) 0 November 22nd 06 05:21 PM
Enter name on 1st worksheet and have it auto. enter on all others pattyh Excel Discussion (Misc queries) 4 March 9th 06 12:24 AM
WYA Converts to WAY after pressing enter ket Roger Cookson Excel Discussion (Misc queries) 3 December 16th 05 05:24 PM


All times are GMT +1. The time now is 06:25 PM.

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

About Us

"It's about Microsoft Excel"