Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Fomat Cell

I'm trying to format an Excel spreadsheet cell to accept the number 08-83.
When I type 08-83 in the disired cell and tab to the next cell the numbers
30529 appear. I do not want to have to enter an apostrophe ' ahead of the
number to overwrite my entry, help! Thanks.
 
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
Import data from Excel into Word document fomat Angela Excel Discussion (Misc queries) 3 September 14th 07 03:35 PM
I wish to fomat numbers in Excel Rumina Excel Worksheet Functions 4 September 6th 07 02:55 PM
how do I fomat cell for latitude Charlie Excel Discussion (Misc queries) 1 October 2nd 06 12:50 PM
Time Fomat Thornpaw Excel Worksheet Functions 3 February 13th 06 02:21 PM
loosing test fomat after using replace command Richard Miller Excel Worksheet Functions 1 October 27th 05 03:46 PM


All times are GMT +1. The time now is 01:48 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"