LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
ketrash
 
Posts: n/a
Default Numbers entered change to 0

Hello. I have a worksheet that for no apparent reason began converting
numbers to 0. For example, if I entered 7 it changed to 0. The next column
was 7*0.3 and it displayed *024. The worksheet was working and designed to
calculate mileage at .30/mile. It is not a formatting problem. Been there!
Thank you so much.

 
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
Change Row Numbers in Formula with Macro Frank Excel Discussion (Misc queries) 3 January 4th 05 06:42 PM
Is there an automatic way to change numbers such as 12312001 t curtev Excel Discussion (Misc queries) 1 December 29th 04 10:32 PM
Random Numbers Change? Les Coover Excel Worksheet Functions 2 December 17th 04 02:49 AM
how do you change invoice numbers automaticly wendy New Users to Excel 1 December 11th 04 12:42 AM
micosoft excel dates entered but changed to sequencial numbers ho. ten twenty Excel Worksheet Functions 1 December 10th 04 02:29 AM


All times are GMT +1. The time now is 12:29 AM.

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"