LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Disapprearing Zero

Hello, If anyone can help. I am using a excel for filling out time sheets
where I work and when I enter the start time of my job excel is kicking out a
number. for example I need to input this 0830 when I hit enter or move to
next cell it turns into this 830. Problem is that it must be a 4 digit entry
for my employer. Is there a way to stop excel from taking out the 0.. by the
way it is only zero that is kicking out no other numbers.

Thanks for the help,


 
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



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