Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default cells changing from number to date

I am putting a number in a cell, then tabbing to the next cell, the previous
cell changed from a number to a date. How do I keep the number there?
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

What are you inputting, a fraction?if so, format as # ??/??

--

HTH

RP
(remove nothere from the email address if mailing direct)


" wrote in
message ...
I am putting a number in a cell, then tabbing to the next cell, the

previous
cell changed from a number to a date. How do I keep the number there?



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
Linked cells show wrong number Guy Links and Linking in Excel 4 April 21st 23 08:07 PM
Counting the number cells between two dates Dave Excel Discussion (Misc queries) 3 March 16th 05 03:30 PM
Seed date formats to different year in different cells KR Excel Discussion (Misc queries) 4 February 12th 05 01:02 AM
Min/Max formulas using cells with date format WDS2000 Excel Worksheet Functions 1 February 7th 05 07:03 PM
split combined Time Date cells Mark Ada Excel Discussion (Misc queries) 2 December 1st 04 04:06 AM


All times are GMT +1. The time now is 01:20 PM.

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"