Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Paul KdN
 
Posts: n/a
Default When I enter a number in an empty cel, de cel returns the value d.

When I enter a number in an empty cel, de cel returns the value divided by 100.

so in een new worksheet as well in my saved xls files entering 900 returns 9
and entering 6 returns 0,06. Profile and cel format are standard.

This started after a crash.
  #3   Report Post  
Paul KdN
 
Posts: n/a
Default

Thanks, the problem was a check in automatic percentage input.

"CLR" wrote:

Maybe try..........

Tools Options un-check Fixed Decimal

Vaya con Dios
Chuck, CABGx3


"Paul KdN" <Paul wrote in message
...
When I enter a number in an empty cel, de cel returns the value divided by

100.

so in een new worksheet as well in my saved xls files entering 900 returns

9
and entering 6 returns 0,06. Profile and cel format are standard.

This started after a crash.




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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 04:21 AM
When we enter a 16 digit number (credit card) the last digit chan. ceking Excel Discussion (Misc queries) 5 December 8th 04 11:45 PM
You Must Enter A Number In This Cell la90292 Excel Discussion (Misc queries) 3 December 4th 04 07:46 PM
Empty Cells, Spaces, Cond Format? Ken Excel Discussion (Misc queries) 3 December 4th 04 04:47 PM


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