Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
green51
 
Posts: n/a
Default how do i stop excel from changing a dash to a zero in a cell?

when I put a dash (0005 - 001) excel changes the dash to a zero and it is
driving me freakin crazy. It just started doing this.
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default how do i stop excel from changing a dash to a zero in a cell?

Look if you have a dash replaced with a zero under toolsautocorrect options
somebody might have joked with you

--
Regards,

Peo Sjoblom

(No private emails please)


"green51" wrote in message
...
when I put a dash (0005 - 001) excel changes the dash to a zero and it is
driving me freakin crazy. It just started doing this.


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
How can I populate an Excel cell based on the data in another cell JerseyBoy Excel Worksheet Functions 3 September 30th 05 03:53 PM
When I copy a cell in Excel it will print how do i stop this Excel Man Excel Discussion (Misc queries) 0 September 19th 05 07:19 PM
How can I stop Excel 2003 from changing my hyperlinks on close? blobaugh Excel Discussion (Misc queries) 2 September 8th 05 12:03 AM
how do i get excel to stop changing my input 5-9 to 9-May???? molly Excel Discussion (Misc queries) 3 February 20th 05 09:26 PM
How do I stop excel from changing single numbers like 1 into a de. Jendayii Excel Discussion (Misc queries) 1 January 5th 05 11:03 PM


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